Alteryx Designer Desktop Knowledge Base

If you are developing with Alteryx's In-Database tools you may want to share the workflows with users who do not have as much database experience. Below is an example workflow to create amacro that will allow your users to select which fields are brought out of the in database tools without interacting with the in database tools directly.

Hive ODBC can be slow when writing to tables. If you are looking for a faster option to write to Hive and want to create a new table or overwrite an existing table, use the IN-DB tools to output your data. 

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.

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"}]

User is trying to use LENGTH to determine the length of a value and getting an error.

User is getting an error with Union In-DB tool: Syntax or semantic analysis error thrown in server while executing query. Error message from server: Error while compiling statement: FAILED: SemanticException Schema of both sides of union should match.

User gets a Win32 Exception when trying to connect to a database or edit a query

This article contains a list of common causes for being unable to run a workflow on a Gallery and solutions for each cause.

When trying to set up a System alias, but the System option is missing. How to troubleshoot this issue.

How To: Change Date Type Coming Out of Date Interface Tool to Match In-DB Field Date

Error: "Query timeout" when running a workflow connected to Amazon Athena.

How to clear the INDBC file history in the Manage In-DB Connections window.

Not able to clear the connection string history. There is no option or button to clear it.

An in depth look at how Apache Spark works with Alteryx and the data sources available.

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.

What is the delimiter when writing In-DB via HDFSC

How to download and install SQL Server ODBC drivers.

Error: "ORA-12170: TNS:Connect timeout occurred" when running a workflow.

Receiving timeout errors when attempting to use the MultiSubnetFailover=true parameter in a SQL Server Availability Group with a multi-subnet listener.

The message, "Error while trying to retrieve text for error ORA-12705" occurs when using multiple IN-DB tools to different Oracle connections.

Numeric values show "[Null]" instead of a blank cell using the Input Data tool.