Alteryx Designer

Definitive answers from Designer experts.
Register for the upcoming Live Community Q&A Session - and don't forget to submit your questions for @DeanS regarding the future role of analytics here.
User is attempting to connect to Hadoop Hive with Active Directory Kerberos (Kerberos SSPI) in Alteryx and getting an error: Failed to get username: Routine Error: Unspecified GSS failure. Minor code may provide more information. The test button in the ODBC DSN is successful.
View full article
Where do you start when you see "An Unhandled Exception occurred"?
View full article
This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.
View full article
In-DB tools add a SELECT statement to Common Table Expression (CTE) queries.
View full article
Connecting to an Oracle APPS schema causes Designer to get stuck in "Not Responding".
View full article
This is a workaround for connecting to an Oracle database that uses LDAP authentication.
View full article
Error: "ORA-12592 TNS Bad Packet Error" occurs when running a workflow.
View full article
All the In-DB connections in Alteryx Designer are lost. Where are these settings stored?
View full article
Not able to clear the In-DB connection string history. There is no option or button to clear it.
View full article
Troubleshoot and solve the Hive error message "Syntax or semantic analysis error thrown in server while executing query."
View full article
Error, "Error SQLPrepare: [Teradata][ODBC Teradata Driver][Teradata Database] The object name is too long in NFD/NFC." when connecting to Teradata.
View full article
Select Tool fields show as missing & data types show unknown when querying from a database
View full article
User encounters an error due to invalid character in table name: Data Stream In (6)    Executing PreSQL: "CREATE TABLE table-name¶ROW FORMAT SERDE¶'org.apache.hadoop.hive.serde2.avro.AvroSerDe'¶STORED AS INPUTFORMAT¶'org.apache.had..." : [Simba][Hardy] (80) Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error running query: org.apache.spark.sql.catalyst.parser.ParseException: ¶mismatched input '-' expecting (line 1, pos 18)¶¶== SQL ==¶CREATE TABLE table-name¶------------------^^^¶ROW FORMAT SERDE¶'org.apache.hadoop.hive.serde2.avro.AvroSerDe'¶STORED AS INPUTFORMAT¶'org.apache.hadoop.hive.ql.io.avro.AvroContainerInputFormat'¶OUTPUTFORMAT¶'org.apache.hadoop.hive.ql.io.avro.AvroContainerOutputFormat'¶TBLPROPERTIES (¶'avro.schema.literal'= '{ "type": "record", "name": "Alteryx", "fields": [{ "type": ["null", "string"], "name": "field1"},{ "type": ["null", "string"], "name": "field2"},{ "type": ["null", "string"], "name": "field3"}]
View full article
The message, "Error while trying to retrieve text for error ORA-12705" occurs when using multiple IN-DB tools to different Oracle connections.
View full article
While trying to connect the Oracle DB through Designer, it results in the below error: "Connection Error: Attempt to load Oracle client libraries threw BadImageFormatException. This problem will occur when running in 64 bit mode with the 32 bit Oracle client components installed." You have installed 64 Bit Oracle 11g client in the machine, where you have the Designer.
View full article
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. 
View full article
Guide to In-DB Connection Files   Introduction In-DB connection files can be used as an alternative way for users to connect to a database. These files are stored as .indbc files and can, in many cases, be the preferred route for connecting to a database. This guide will walk through reasons for setting up a file connection, suggestions on storing the files on a network location, and steps to set this up.   There are many reasons to use an In-DB connection file:   Centralize data connection(s) in one location so that they can be used across multiple workflows and/or multiple users Have a single location where data connections can be modified, or credentials updated Allow access to data connections from multiple systems or server nodes Avoid having to set up ODBC DSNs on multiple Designer machines or server nodes Avoid Designer users needing to know credential information Things to know before you start Nothing prevents users who have access to file share location where File-based data connections are stored from downloading and sharing connection files with others. The passwords will not be visible because they are encrypted, but the connections will work on other Alteryx machines. Permissions will need to be controlled via the standard Windows permissions. These will only work with data sources that support In-DB through Alteryx: See Supported Data Sources and File Formats How to create the In-DB file connection(s) on a file share Whoever is going to create the data connection file will need to be on a machine that has Alteryx Designer installed.   1. Install the data source driver (if it is not already installed). You will eventually need to install the driver on all the machines that may connect to this data source. See the above Supported Data Sources link to see tested drivers and versions.   2. Create a DSN-less data connection. DSN-less connections provide ultimate portability as the connection string specifies the driver, host and authentication parameters and avoids needing to set up an ODBC DSN on all machines that will be connecting.   Example connection formats (notice the driver is part of the connection string):           odbc:DRIVER={SQL Server Native Client 11.0};UID=xxx;PWD=xxx;DATABASE=MyDatabase;SERVER=myserver.somedomain.com; odbc:DRIVER={Simba Hive ODBC Driver};Host=myserver.somedomain.com;Port=10000;UID=hdfs         odbc:DRIVER={SnowflakeDSIIDriver};Server=myserver.snowflakecomputing.com;Warehouse=mywarehouse;Database=mydatabase;Schema=PUBLIC;Role=;Uid=xxx;Pwd=xxx;         *For more information on connection strings, please see ConnectionStrings.com or contact your DBA who can get this for you.   3. Create the connection in Designer. Go to Options > Advanced Options > Manage In-DB Connections 1. Choose your Data Source type 2. Choose Connection Type to be “File” 3. Browse to the file share and name the file. It should be saved to a fully-qualified UNC path i.e.:         \\fileshare.domain.com\fileconnections\oracle.indbc       4. Set Password Encryption to “Hide” 5. Paste your DSN-less connection string in the Connection String area for Read. 6. Paste your DSN-less connection string in the Connection String area for Write. (Note that Read and Write need to be both specified and can be the same string, or different if need be) 7. Click Ok to save the connection file.       4. Build a workflow that uses In-DB tools to connect to your data source using the saved file to test the connection  5. Set the file or directory permissions for the connection file so they are restricted to only allow read access to users that should have access. This would include the Run-As user (if specified in the Alteryx System Settings) or users utilizing Workflow Credentials. More info on this can be found in the following articles:  How Workflow Credentials Work on a Private Gallery Set Required Run As User Permissions 6. Publish the workflow to the server. Make sure the In-DB connection file is not included as an asset.    Note: Credit for this article goes to the Alteryx Solutions Architects team!
View full article
We are working diligently and intelligently on making connections to databases easier, more secure, and faster in Alteryx. Even when we can make the best possible experience for our users come to fruition, any user may still encounter some issues due to the use of third party drivers and/or the intricate communications between the database, driver, and Alteryx. To help to minimize those issues, Alteryx is tested with an abundance of "supported" databases and drivers that are proven to be compatible but, unfortunately, you just can't test every database and every driver out there. Our technical specifications page found here will show you those databases Alteryx supports, as well as the drivers we have tested and support with respect to each database. This does not mean Alteryx will not connect to a database or driver you do not see on this page (or links within the page), however, Alteryx can not support those databases and/or drivers if troubleshooting or setup is required.
View full article
Issue   When connecting to an OleDB Datasource using the either the Input Tool or the In-DB Tools, users can encounter the below error message :         Error opening connect string: Microsoft SQL Server Native Client 11.0: Login failed for user 'user1'.\28000 = 18456   Environment   Alteryx Designer Drivers : OleDB Providers for Microsoft SQL Server   Diagnosis   Usually, when testing the Data Connection through the OleDB "Data Link Properties" window they are able to successfully test the connection :     However the error message will persist from the canvas.   Cause   When mentioning a username/password combination in a connection string, they need to be extracted in the program calling for it. A parameter will need to be set and added to the string so windows remembers the credentials and they can be extracted in program.   Solution   Open the Driver's configuration "Data Link Properties" window Go to the "All" tab Identify the Persist Security Info parameter - at this time it should be set to False Double-click and on this parameter and set it to True Apply all the changes Run the Tool on Designer again   Additional Resources   How To: Connect to an OleDB Data Source Database Issues – Working with Alteryx Customer Support Engineers (CSEs)     As always, don't hesitate to contact us over at Customer Support if you run into any trouble.
View full article
How To: Build Queries without using the Visual Query Builder   The Visual Query Builder window can take a long time to load because it always loads all column metadata for all tables for all schemas, even if a default database is selected in the database connection. This article will walk through using the In-Database tools as an alternative to using the Visual Query Builder.    Prerequisites   Alteryx A working Database connection This works best for connections supported for In-DB as noted in the Supported Data Sources and File Formats   Procedure   The Tables view loads only tables names and no column names for the default database selected and it caches the list. This allows it to load faster than the Visual Query Builder.   Make the Tables View the default view Drag an Input tool on the canvas and connect to a database (it doesn't have to be the database in question, any database will work) Click the Tables view and click the checkbox next to "Open Tables view by default" at the bottom left of the window  Create an In-DB Connection to your database as described here: How To: Create an In-Database Connection Use a Connect In-DB tool to connect to the database. To build your query: Select the table name in the Tables view. This creates a SELECT * FROM TABLE statement with no criteria to limit the query Use the In-DB tools to build the query. e.g. the Select In-DB tool to select only columns you need or the Filter In-DB to remove rows not needed Alteryx constructs a SQL query based on the tools on the canvas and sends it to the database In the example below, both workflows accomplish the same thing, one through the Visual Query Builder, one using the In-DB tools:   Additional Resources   FAQ: How Do the In-Database tools Work? How To: Create an Alteryx In-DB Connection File Database Issues – Working with Alteryx Customer Support Engineers (CSEs)
View full article