Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Knowledge Base

Definitive answers from Designer Desktop experts.
Error: "Cursors are not supported" or "Cursor support is not an implemented feature" when running a workflow against SQL Server or Azure Synapse.
View full article
Not able to select a different database for existing Gallery connections for SQL Server within Designer.
View full article
Error: "Query timeout" when running a workflow connected to Amazon Athena.
View full article
Spatial Data from SQL Server shows up as "None", "Null", or other characters in the Input Data tool.
View full article
How to clear the INDBC file history in the Manage In-DB Connections window.
View full article
Not able to clear the connection string history. There is no option or button to clear it.
View full article
An in depth look at how Apache Spark works with Alteryx and the data sources available.
View full article
In this article, I am going to show you how to load data into snowflake using Alteryx Database Connections!
View full article
Alteryx has the ability to create and query Pre and Post SQL statements. Using this feature is good if you need to create a temporary table, delete or update the table before running the select. With this, you also have the ability to run stored procedures (via exec stored_procedure;) before and after the actual query as well.
View full article
Stored Procedures are a batch of SQL statements that can be executed in a couple of ways
View full article
Oracle database character set is AL32UTF8. The field defined is VARCHAR2. Writing back some Chinese characters to this field using OCI ends with garbled characters.
View full article
32 bit connections no longer supported in 21.3.
View full article
This article provides steps to connect to Redshift from Designer.
View full article
What is the delimiter when writing In-DB via HDFSC
View full article
Error while connecting to a database, from the Input Data Tool - Error: Input Data (13): Error SQLDriverConnect: [Microsoft][ODBC Driver Manager] The specified DSN contains an architecture mismatch between the Driver and Application.
View full article
"Error: Input Data (1): Error opening connect string: Microsoft OLE DB Provider for SQL Server: [DBNETLIB][ConnectionOpen (SECDoClientHandshake()).]SSL Security error.\08001 = 18" after upgrading SQL Server to 2019 and disabling TLS 1.0 and 1.1
View full article
SQL Server read performance is slow in Designer.
View full article
How to download and install SQL Server ODBC drivers.
View full article
Error: "ORA-01652: unable to extend temp segment by 64 in tablespace TEMP" in workflow connected to Oracle.
View full article
Error: "ORA-12170: TNS:Connect timeout occurred" when running a workflow.
View full article