Alteryx Designer Knowledge Base

How to improve performance when reading from or writing to Snowflake.

An overview of Azure applications and how they are used by Alteryx Designer to securely access your data.

When exporting a large amount of data from Databricks (over 500k rows), a result file download error is received.

During run time of workflow, the following error is received:

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.

When a folder name starts with a period (.), the Input Data tool throws a "Can't find the file" error.

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".

Receive error “Get Table List Error: Win32 Exception” when connecting to Databricks.

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.

Error: "Input Data (1117): Internal Error: Invalid parameter detected in function (null). File: (null) Line: 0 Expression: (null)." when pulling data from PostgreSQL

When connecting to Snowflake to pull data into the Input Data tool receives an error

When connecting to Databricks and querying long text fields, the data being returned is truncated to 254 characters.

Certain maps are missing in the Base Map option after a recent Designer upgrade.

Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.

Opening an Excel binary file (.XLSB) in an Input Data Tool crashes Designer if Windows patches are not installed.

A column with spatial data and spaces in the column name throws a "Incorrect syntax" error when reading from or writing to SQL Server.

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.

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.

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

Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.

How to format common ODBC DSN-less connection strings