Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
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
Error: "Unsupported data type 'bit'", when writing data with a Boolean to Snowflake.
View full article
Error: "Login failed for user ' '" when connecting to SQL Server with Azure Active Directory.
View full article
Workflow worked in versions before 2020.3 After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord"
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
"No table chosen; Please select a Table from data source".
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
Error: "There were errors with LOADING please check your ERROR TABLES", when writing data using Output Data tool to Teradata.
View full article
Reading and Writing spatial data from/to Redshift
View full article
Error: "ORA-00900: invalid SQL Statement" occurs when running a procedure in the Pre or Post SQL Statement for Input or Output Data tools.
View full article
User is getting an error writing an excel file to a shared drive.
View full article
Calgary Loader (2) PagedFile::Add: keys out of order, sort not supported yet.
View full article
Troubleshooting error with Publish to Tableau Server tool: TypeError: Cannot read property ‘token’ of undefined
View full article
Snowflake External Tables are not showing in the Alteryx Visual Query Builder tab.
View full article
Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone.
View full article
This KB is extracted from the Inspire 2019 Tips + Tricks and outlines how to connect to a document library (Sharepoint) via Alteryx.
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
Connecting to Google Analytics is becoming more and more popular. There are a few things you need in order to use the Google Analytics macro; a Google Account (e.g., Gmail) and authorized access to an existing Google Analytics account. This article will help you get the rest of the way.
View full article