Alteryx Designer Desktop Knowledge Base

ORA-12154: TNS: could not resolve the connect identifier specified

How to find the relevant information and configure a Databricks connection through the Manage In-DB Connections window. The Databricks connection includes bulk loading capabilities that allow users to load large data sets faster. 

Instructions for XLSX legacy option, XLSB and accdb.

This article discussed about the Alteryx Connectors deprecation, for initial set of connectors, and clarifies the questions around the Connectors deprecation.

Error: "You have found a bug. Replicate, then let us know. We shall fix it soon." when pulling data from Snowflake.

Error in input tool for Simba Athena driver when schema name contains dash

Error: "An item with the same key has already been added" when selecting Quick Connect

When connected to an Oracle database, the Visual Query Builder will freeze, or Designer occasionally crashes, when trying to select a method of aggregation for a selected column

How to obtain and install the driver and setup ODBC connection DSN connection

ERROR: "General error; 1033 error while parsing protocol" while connecting to SAP HANA DB using the Input Data Tool in Designer

How to Edit Environment Variables for Oracle Data Connection

Where do you start when you see "An Unhandled Exception occurred"?

This article provides answers the most frequently asked questions related to In-Database Tools.

After upgrading Designer, clicking on the ellipsis(...) to launch the Query Builder window, results in error "Could not load type 'ActiveDatabaseSoftware.ActiveQueryBuilder.SnowflakeMetadataProvider' from assembly 'ActiveDatabaseSoftware.ODBCMetadataProvider2"

During run time of workflow, the following error is received:

How to Connect to Databases Outside of Alteryx.

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.

When trying to connect to a snowflake database, I am getting the error CURLerror (curl_easy_perform() failed) - code = 6 msg = 'Couldn't resolve host name'.

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

Error: "Failed to connect to okta. Error code=401" when connecting to Snowflake using Okta SSO and MFA.

How to format common ODBC DSN-less connection strings