Alteryx Designer Knowledge Base

How to format common ODBC DSN-less connection strings

Error: "Incompatible with the Client software" when connecting to Teradata in Designer

Error: "Unsupported data type 'bit'", when writing data with a Boolean to Snowflake.

Error: "Login failed for user ' '" when connecting to SQL Server with Azure Active Directory.

Workflow worked in versions before 2020.3 After upgrading to 2020.3 receive error "An unknown error occurred in II_PushRecord"

Receiving timeout errors when attempting to use the MultiSubnetFailover=true parameter in a SQL Server Availability Group with a multi-subnet listener.

"No table chosen; Please select a Table from data source".

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.

Error: "There were errors with LOADING please check your ERROR TABLES", when writing data using Output Data tool to Teradata.

Reading and Writing spatial data from/to Redshift

Alteryx creates 2 .BAK files

Error: "ORA-00900: invalid SQL Statement" occurs when running a procedure in the Pre or Post SQL Statement for Input or Output Data tools.

User is getting an error writing an excel file to a shared drive.

Calgary Loader (2) PagedFile::Add: keys out of order, sort not supported yet.

Troubleshooting error with Publish to Tableau Server tool: TypeError: Cannot read property ‘token’ of undefined

Snowflake External Tables are not showing in the Alteryx Visual Query Builder tab.

Troubleshooting: Error creating a Snowflake Table

Error: "HTTP Error 403: Forbidden", when using Output Data tool to Hive HDFS in an encrypted zone.

This KB is extracted from the Inspire 2019 Tips + Tricks and outlines how to connect to a document library (Sharepoint) via Alteryx.

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.

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.