We are aware of an issue with the Search bar. Please use Advanced search for the time being while we troubleshoot. Thanks for your patience as we work on improving the community!

Alteryx Designer Knowledge Base

Definitive answers from Designer experts.
How to Edit Environment Variables for Oracle
View full article
"drop table" command with IN-DB tool doesn't work with IN-DB tool
View full article
Error: "FATAL: password authentication failed for user" when PostgreSQL or Greenplum credentials contain special characters when connecting in Designer.
View full article
Not able to clear the connection string history. There is no option or button to clear it.
View full article
How to clear the INDBC file history in the Manage In-DB Connections window.
View full article
How to format common ODBC DSN-less connection strings
View full article
Error: "Query timeout" when running a workflow connected to Amazon Athena.
View full article
When trying to read data from Hive, the error: "SQLPrepare: [Simba][Hardy] (80) Syntax or semantic analysis" is thrown in the server while executing a query.
View full article
How to download and install SQL Server ODBC drivers.
View full article
Where do you start when you see "An Unhandled Exception occurred"?
View full article
Error: "ORA-12170: TNS:Connect timeout occurred" when running a workflow.
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
Troubleshooting Database Connections
View full article
Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.
View full article
We are proud to introduce you to the Manage Data Connection functionality in 11.0!
View full article
Receiving timeout errors when attempting to use the MultiSubnetFailover=true parameter in a SQL Server Availability Group with a multi-subnet listener.
View full article
"No table chosen; Please select a Table from data source".
View full article
User gets a Win32 Exception when trying to connect to a database or edit a query
View full article
The message, "Error while trying to retrieve text for error ORA-12705" occurs when using multiple IN-DB tools to different Oracle connections.
View full article
User is getting an error with Union In-DB tool: Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException Schema of both sides of union should match.
View full article