We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
Visual Query Builder does not populate schemas containing only views for Snowflake
View full article
SQL Server read performance is slow in Designer.
View full article
How to Edit Environment Variables for Oracle
View full article
Error: "FATAL: password authentication failed for user" when PostgreSQL or Greenplum credentials contain special characters when connecting in Designer.
View full article
Not able to clear the connection string history. There is no option or button to clear it.
View full article
Spatial Data from SQL Server shows up as "None", "Null", or other characters in the Input Data tool.
View full article
How to format common ODBC DSN-less connection strings
View full article
When using Excel spreadsheets in Alteryx, sometimes there may be difficulty in reading the data. Viewing the spreadsheets in XML format is an excellent way to check for encoding or formatting issues.
View full article
Error: "Query timeout" when running a workflow connected to Amazon Athena.
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
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
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