Alteryx Designer Desktop Knowledge Base

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. 

Error SQLExecute: Internal Query Processor Error: The query processor could not produce a query plan. For more information contact Customer Support Services.

Step by Step guide to support users to connect to Snowflake through Alteryx, from downloading the driver to data.

This article will walk through the process of creating remote tables in Denodo using the Alteryx Output Data tool.

Error In-DB Databricks

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.

When writing to Google BigQuery using the Google BigQuery Bulk data connection from the Data Connection Manager (DCM), you may encounter an error about GoogleCloudWriter having issues with retrieving the database name. This issue can be resolved by verifying the configuration in the DCM connection.

How to Edit Environment Variables for Oracle Data Connection

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

How to improve performance when reading from or writing to Snowflake.

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

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

When querying data with ROWID using Oracle OCI driver with the Input Data and Connecting IN-DB tools will result in the following errors: "You have found a bug".

When connecting to Databricks and querying long text fields, the data being returned is truncated to 254 characters.

Workaround for defect TDCB-1263/DE20744 that was fixed in Designer version 2021.4.

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

When using Simba Snowflake 2.23.02.1012 some NULL values are transformed into encoded values

How to collect Wireshark traces to troubleshoot network-related issues.

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

DE30000 / GDC-1220: Snowflake Receive "ERROR: SQLPrepare: SQL compilation error:¶duplicate alias 'Tool1_7c8a' when using Inner Join In-DB Tool with the same Table" when using Inner Join In-DB Tool