Alteryx Designer Desktop Knowledge Base

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"

During run time of workflow, the following error is received:

How to Connect to Databases Outside of Alteryx.

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.

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"

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

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.

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""

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".

Can't Synchronize DCM to Server

Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.

When connecting to Databricks and querying long text fields, the data being returned is truncated to 254 characters.

Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.

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'.

A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.

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.

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

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.

Receive "ERROR: The session is read-only" using pre/post SQL option in the Input Data tool when attempting to perform any operation that is not a select statement, such as dropping/creating tables

Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.

How to format common ODBC DSN-less connection strings