Inspire EMEA 2022 On-Demand is live! Watch now, and be sure to save the date for Inspire 2023 in Las Vegas next May.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
How to improve performance when reading from or writing to Snowflake.
View full article
An overview of Azure applications and how they are used by Alteryx Designer to securely access your data.
View full article
During run time of workflow, the following error is received:
View full article
This directory was generated by the Alteryx install script, and contains an instance of the Oracle Instant Client. Oracle Instant Client is a collection of installed Oracle Database libraries for connecting Alteryx Designer to local or remote Oracle Databases. There’s no need for tnsnames.ora file.
View full article
When a folder name starts with a period (.), the Input Data tool throws a "Can't find the file" error.
View full article
When querying data with ROWID using Oracle OCI driver with the Input Data and Connecting IN-DB tools will result in the following errors: "You have found a bug".
View full article
Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.
View full article
This document explains the steps to export HAR files by using Chrome Developer Tools built into Designer to investigate the interface of HTML GUI SDK tools.
View full article
Error: "Input Data (1117): Internal Error: Invalid parameter detected in function (null). File: (null) Line: 0 Expression: (null)." when pulling data from PostgreSQL
View full article
When connecting to Databricks and querying long text fields, the data being returned is truncated to 254 characters.
View full article
Certain maps are missing in the Base Map option after a recent Designer upgrade.
View full article
Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.
View full article
Opening an Excel binary file (.XLSB) in an Input Data Tool crashes Designer if Windows patches are not installed.
View full article
A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.
View full article
When adding a SQL Server Database Connection via the Input Data tool’s SQL Server Quick Connect, the Test button is missing when the Authentication Type is set to Windows Authentication.
View full article
DCM connection fails if the query has lines commented out using – When using a connection set up through DCM you get various syntax errors on queries that has lines commented out using -- . The queries work just fine when using a normal ODBC connection.
View full article
Receive "ERROR: The session is read-only" using pre/post SQL option in the Input Data tool when attempting to perform any operation that is not a select statement, such as dropping/creating tables
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