This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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"
When attempting to Write to MySQL with the output option "Update: Insert if New" you get an error if the table has a composite primary key of multiple fields and none of the data have changed in the row
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 create a temporary table for use in the Data Input Tool (connecting to Google BigQuery) the workflow errors out with "Executing PreSQL: CREATE OR REPLACE TEMPORARY TABLE... Invalid query: Use of CREATE TEMPORARY TABLE requires a script or session"
Publishing workflow to Alteryx Server fails with "Error opening connect string: Microsoft OLE DB Provider for SQL Server: Login failed. The login is from an untrusted domain and cannot be used with Windows authentication.\42000=18452
When you try to insert a record to an Amazon Redshift table which has a column with attribute IDENTITY(seed, step), the record is inserted fine, but the value of the first column to be inserted is null instead of the value being passed into the Output Data tool.
DCM connection fails if the query has lines commented out using –
When using a connection set up through DCM you get various syntax errors on queries that has lines commented out using -- . The queries work just fine when using a normal ODBC connection.