Upgrading Server to version 22.1? We’ve enabled the faster AMP engine by default. Read about how these system settings changes might affect you.

2022-05-26 Updates: Email: If you're not seeing emails be delivered from the Community, please check your spam and mark the Community emails as not junk. Thank you for your patience.

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
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
No Teradata Parallel Transport logs are being created when a workflow, that includes a Teradata Bulk Connection, is executed.
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
Stored Procedures are powerful and helpful, however, in Designer and Server it is required for them to have a return value. If that is not the case the error "no columns returned" will occur.
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
How to fix an error during installation that says "The feature you are trying to use is on a network resource that is unavailable".
View full article
Error "An OLE DB Provider was not specified in the ConnectionString. An example would be, 'Provider=SQLOLEDB'" when converting an ODBC DSN-less connection to OLEDB
View full article
Visual Query Builder does not populate schemas containing only views for Snowflake
View full article
This article details different methods for connecting to an Oracle database from Alteryx.
View full article
How to set up a DSN-less connection to Salesforce that allows you to specify which version of the API you'd like to use when outputting data.
View full article
Unable to configure or select Simba Oracle driver in system ODBC dialogue due to system error code 126
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
Steps to troubleshooting an "Unhandled Exception" error when attempting to open the Manage Data Connections window.
View full article
The guide covers SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, CROSS JOIN, WHERE BETWEEN, WHEREIN, DISTINCT and we hope you find it helpful.
View full article
When doing Teradata bulk loader There's no difference between the two output options Append (Ignore Duplicate Rows) and Append (Mark duplicate Rows).
View full article
Troubleshooting Database Connections
View full article
We are proud to introduce you to the Manage Data Connection functionality in 11.0!
View full article