ALTERYX INSPIRE | Join us this May for for a multi-day virtual analytics + data science experience like no other! Register Now

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
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
Not able to select a different database for existing Gallery connections for SQL Server within Designer.
View full article
When connecting to a DB2 Database via ODBC in Designer, some Date datatype from a column are coming up Null
View full article
Error: "Cursors are not supported" or "Cursor support is not an implemented feature" when running a workflow against SQL Server or Azure Synapse.
View full article
Error: Can’t find the file: “[path\FileName]”. Make sure the file path is correct. Error text being revised from Error: File not found "[path\FileName]"
View full article
How to download and install SQL Server ODBC drivers.
View full article
Error: "ORA-12170: TNS:Connect timeout occurred" when running a workflow.
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
How to format common ODBC DSN-less connection strings
View full article
Error: "Incompatible with the Client software" when connecting to Teradata in Designer
View full article
Display issues when reading data with unicode characters from Oracle
View full article
Error: "Must declare the scalar variable '@var_name'" when running PL/SQL in Pre or Post SQL Statement Section.
View full article
This KB outlines the workaround for DE18888 where Cyrillic characters from DB2 are not displaying in Designer
View full article
Learn about upcoming changes to Alteryx support of 32-bit database connections and start planning today
View full article
Error: "Login failed for user ' '" when connecting to SQL Server with Azure Active Directory.
View full article
Here we’ll delve into uses of the Text Input Tool on our way to mastering the Alteryx Designer:
View full article
Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.
View full article
Querying a date from the Alteryx Server Persistence MongoDB using the MongoDB Input tool can be tricky since Alteryx Server dates are stored as string values. Here is how to use regex in the criteria section of the MongoDB Input tool.
View full article
Receiving timeout errors when attempting to use the MultiSubnetFailover=true parameter in a SQL Server Availability Group with a multi-subnet listener.
View full article
Error: "CURLerror (curl_easy_perform() failed) - code=35 msg='SSL connect error'." when connecting to Snowflake.
View full article
User gets a Win32 Exception when trying to connect to a database or edit a query
View full article