Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
the issue occurs when opening a data source in Designer
View full article
When upgrading to 2022.3 the previous way of formatting in the SQL Editor Parser no longer yields a successful query. You have to move the lines up one so that one of the entries (if multiple entries are listed) are next to the Select field and also the same for the From field.
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
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