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
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
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
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
Troubleshooting Database Connections
View full article
We are proud to introduce you to the Manage Data Connection functionality in 11.0!
View full article
How To: Gather ODBC Logs for troubleshooting
View full article
User is attempting to connect to Hadoop Hive with Kerberos in Alteryx and getting an error: Failed to get username: Routine Error: Unspecified GSS failure. Minor code may provide more information. The test button in the ODBC DSN is successful.
View full article
Using SQL Server connections, "date" datatype fields are changed to "V_WString"
View full article
How to Sort with IN-Database tools
View full article
Error: "ORA-12557: TNS: protocol adapter not loadable" when trying to connect to an Oracle database
View full article
Error: "System.Data.OracleClient requires Oracle client software version 8.1.7 or greater" when connecting to Oracle.
View full article