Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
How to find the relevant information and configure a Databricks connection through the Manage In-DB Connections window. The Databricks connection includes bulk loading capabilities that allow users to load large data sets faster. 
View full article
Error SQLExecute: Internal Query Processor Error: The query processor could not produce a query plan. For more information contact Customer Support Services.
View full article
Step by Step guide to support users to connect to Snowflake through Alteryx, from downloading the driver to data.
View full article
This article will walk through the process of creating remote tables in Denodo using the Alteryx Output Data tool.
View full article
When trying to read data from Hive, the error: "SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis" is thrown in the server while executing a query.
View full article
When writing to Google BigQuery using the Google BigQuery Bulk data connection from the Data Connection Manager (DCM), you may encounter an error about GoogleCloudWriter having issues with retrieving the database name. This issue can be resolved by verifying the configuration in the DCM connection.
View full article
How to Edit Environment Variables for Oracle Data Connection
View full article
Where do you start when you see "An Unhandled Exception occurred"?
View full article
This article provides answers the most frequently asked questions related to In-Database Tools.
View full article
During run time of workflow, the following error is received:
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
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
Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.
View full article
How to format common ODBC DSN-less connection strings
View full article
When using Simba Snowflake 2.23.02.1012 some NULL values are transformed into encoded values
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
View full article
Receive error "ORA-00942 - table or view does not exist" or "ORA-00903 - invalid table name" using output mode to "Append Existing" even though the table exists
View full article
DE30000 / GDC-1220: Snowflake Receive "ERROR: SQLPrepare: SQL compilation error:¶duplicate alias 'Tool1_7c8a' when using Inner Join In-DB Tool with the same Table" when using Inner Join In-DB Tool
View full article
Receive Error: " The query resulted in multiple columns named "FIRST_NAME". Please resolve your query to return uniquely named columns." with Connect In-DB tool when query has a Join (Inner Join, Right Join, etc)
View full article