Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
How to improve performance when reading from or writing to Snowflake.
View full article
After upgrading Designer, clicking on the ellipsis(...) to launch the Query Builder window, results in error "Could not load type 'ActiveDatabaseSoftware.ActiveQueryBuilder.SnowflakeMetadataProvider' from assembly 'ActiveDatabaseSoftware.ODBCMetadataProvider2"
View full article
When attempting to Write to MySQL with the output option "Update: Insert if New" you get an error if the table has a composite primary key of multiple fields and none of the data have changed in the row
View full article
During run time of workflow, the following error is received:
View full article
How to Connect to Databases Outside of Alteryx.
View full article
This directory was generated by the Alteryx install script, and contains an instance of the Oracle Instant Client. Oracle Instant Client is a collection of installed Oracle Database libraries for connecting Alteryx Designer to local or remote Oracle Databases. There’s no need for tnsnames.ora file.
View full article
When trying to create a temporary table for use in the Data Input Tool (connecting to Google BigQuery) the workflow errors out with "Executing PreSQL: CREATE OR REPLACE TEMPORARY TABLE... Invalid query: Use of CREATE TEMPORARY TABLE requires a script or session"
View full article
Publishing workflow to Alteryx Server fails with "Error opening connect string: Microsoft OLE DB Provider for SQL Server: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.\42000=18452
View full article
When you try to insert a record to an Amazon Redshift table which has a column with attribute IDENTITY(seed, step), the record is inserted fine, but the value of the first column to be inserted is null instead of the value being passed into the Output Data tool.
View full article
Whenever attempting to connect HDFS to a Dynamic Input Tool, users may encounter the error: "Server root URL must be in the form "http://server:port""
View full article
When querying data with ROWID using Oracle OCI driver with the Input Data and Connecting IN-DB tools will result in the following errors: "You have found a bug".
View full article
Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.
View full article
When connecting to Databricks and querying long text fields, the data being returned is truncated to 254 characters.
View full article
Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.
View full article
When trying to connect to a snowflake database, I am getting the error CURLerror (curl_easy_perform() failed) - code = 6 msg = 'Couldn't resolve host name'.
View full article
A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.
View full article
On setting up a SYSTEM connection on the designer, the connection is added as a user connection. The connection is saved to the UserAlias.xml file and not the SystemAlias.xml file.
View full article
When using Amazon Redshift Bulk Connection, Output Data tool option "Size of Bulk Load Chunks (1 MB to 102400 MB)" is set to default when the Bulk Size value is higher than 4K
View full article
DCM connection fails if the query has lines commented out using – When using a connection set up through DCM you get various syntax errors on queries that has lines commented out using -- . The queries work just fine when using a normal ODBC connection.
View full article