Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
How Alteryx Designer and Server use file paths
View full article
Connector tools that use "Sign in via Internet Browser" do not work correctly with Designer or Server 2021.3.2. To use those tools, you should upgrade to version 2021.3.3 or later and then download and install the tool version that says " Fixed blank screen issue when authenticating in Designer 2021.3.2.54175. Please note that you also need to update to Designer 21.3.3.63061 or later.." Alternatively in the short term, you can use version 2021.3.1 of Designer or Server.
View full article
When using special charater "≥" value in a database Input Data tool, the field displays as "=".
View full article
Nothing happens when clicking on the Save button when manually creating a connection string.
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: "internal error in SRC_GetCosmeticName_Raw" when creating new database connections.
View full article
Platform Product: Designer Issues – Working with Alteryx Customer Support Engineers (CSEs)
View full article
User is attempting to connect to Hadoop Hive with Kerberos in Alteryx and getting an error: Failed to get username: Routine Error: Unspecified GSS failure. Minor code may provide more information. The test button in the ODBC DSN is successful.
View full article
Error "Failed to decrypt data: Key not valid for use in specified state." when trying to connect to Amazon Athena
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
"I have a bajillion files that I need to bring into my workflow... wayyyyyy too many for me to use individual Input Data tools! What's the best way to do this?"                    - every Alteryx user ever
View full article
Error opening "SHOW VARIABLES LIKE 'aurora_version'" when connecting to MariaDB via ODBC.
View full article
If a column name contains brackets, the search function in the results panel would fail.
View full article
The Visual Query Builder is not displaying the table columns for PostgreSQL connection.
View full article
"Error (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170) " when using HIVE ODBC Connection
View full article
Using SQL Server connections, "date" datatype fields are changed to "V_WString"
View full article
Error: "Test Query Error near 'as': syntax error" when executing a 'WITH' clause against a SQLITE table
View full article
When outputting to Oracle, the Designer result panel shows ORA-00001: unique constraint violated.
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