We have extended our Early Bird Tickets for Inspire 2023! Discounted pricing goes until February 24th. Save your spot!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
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
"Error SQLExecute: [SAP AG][LIBODBCHDB DLL][HDBODBC] General error;2048 column store error: search table error: [34023] Instantiation of calculation model failed;exception 306106: Undefined variable: $$variable name$$. Variable is marked as required but not set in the query" when querying SAP Hana object
View full article
When using the Intersect tool to compare the same spatial information between an MRR file and a GRD file, the MMR is showing an offset, when the overlap should be 100%
View full article
Error "Failed to decrypt data: Key not valid for use in specified state." when trying to connect to data source
View full article
Designer 2021.4.1 Excel XLSX Data Input Tool skips initial columns with no data in first row (Row 1)
View full article
For a SQL Server connection, the Test Query in the SQL Editor is returning with message "Error opening : No Columns Returned."
View full article
Visual Query Builder does not populate schemas containing only views for Snowflake
View full article
When using Simba Snowflake 2.23.02.1012 some NULL values are transformed into encoded values
View full article
When user tries to input CSV file that has delimiter character encapsulated in quotes (so that it should not be considered a delimiter), connector will not consider the file valid.
View full article
How to collect Wireshark traces to troubleshoot network-related issues.
View full article
Receive error "ORA-00942 - table or view does not exist" or "ORA-00903 - invalid table name" using output mode to "Append Existing" even though the table exists
View full article
Receive "Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] (-3706) Syntax error: expected something between .. " in input Data Tool
View full article
Error: "The COPY failed with error: End of record reached while expected to parse column" when trying to update Snowflake using Bulk Connection
View full article
Steps to troubleshooting an "Unhandled Exception" error when attempting to open the Manage Data Connections window.
View full article