Alteryx Designer Desktop Knowledge Base

Metadata is not available in Visual Query Builder for MariaDB

The Input Tool does not display any stored procedures.

Error: "Primary Key required for Update option" when using Update option for Output on Hive.

Error opening "SHOW VARIABLES LIKE 'aurora_version'" when connecting to MariaDB via ODBC.

If a column name contains brackets, the search function in the results panel would fail.

Cannot save credentials in Azure Data Lake File (ADLS) connector v2.1.0. Error "Please provide an access token" after authentication.

This article provides details on how to change Alteryx Designer Language

Error: "Error encountered when executing file transfer: Failed to upload file" when using the Snowflake bulk option in the Output data tool.

Not displaying the list of workflow assets.

Data Cleansing tool metadata is not completely retained, following a macro, when the workflow is saved and re-opened.

The Visual Query Builder is not displaying the table columns for PostgreSQL connection.

This article details on the steps to read/extract password protected excel file in Alteryx Designer using the R code.

An error is thrown when scheduling a workflow in Desktop Scheduler in a non-English language. This only occurs with the 'Custom' option under Frequency.

"Error (1170) Unexpected response received from server. Please ensure the server host and port specified for the connection are correct. (1170) " when using HIVE ODBC Connection

So, you are new to Alteryx and you find an administrator version, non-administrator, licenses, predictive tools ... Do not worry, in this guide I will describe step by step the procedure to install Alteryx Designer on your computer. If you require something specific, here is the content of the guide so you can get to what you are looking for faster.

Using SQL Server connections, "date" datatype fields are changed to "V_WString"

Troubleshooting the error: A Regular Expression was not specified.

Troubleshooting the error: An expression must be specified.

Error "ora-28094: SQL Construct Not Supported by Data Redaction" when trying to test sql query - basic select * from objectname

Outputting to SQL Server by the Output Tool option "Create New Table" resulted in CREATE TABLE Permission Denied.

Incorrect number of records being read from an Oracle database. Alteryx appears to be adding 100 duplicate rows