Alteryx to Databricks SQL Troubleshooting

This page maps common Transpiler errors encountered when migrating Alteryx workflows to Databricks SQL to the correct troubleshooting guides. Match the exact error text from your run to quickly jump to the fix.

If you are having trouble with an issue not listed here, contact us through the Prophecy Support Portal.

Unsupported Tool

If you encounter the following error:

The following components are not supported: <ToolName> of type <ToolType>.

Refer to Unsupported Tool.

Unsupported Function

If you encounter the following error:

Cannot resolve routine <FunctionName> on search path [`system`, `builtin`, `system`.`session`, `hive_metastore`.`default`]. Verify the spelling of <FunctionName>, check that the routine exists, and confirm you have `USE` privilege on the catalog and schema, and EXECUTE the routine. SQLSTATE: 42883;

Refer to Unsupported Function.

Malformed File

If you encounter one or more of the following errors:

Unable to load associated entities.

Following files have incorrect format: <filePath>

Transpilation failed with exception: org.xml.sax.SAXParseException; lineNumber: <num> columnNumber: <num> The element type "<elementType>" must be terminated by the matching end tag "<endElementType>".

Refer to Malformed File.

Overview

Alteryx

Informatica

Ab Initio

DataStage

Alteryx to Databricks SQL Troubleshooting

Unsupported Tool

Unsupported Function

Malformed File

​Unsupported Tool

​Unsupported Function

​Malformed File

Unsupported Tool

Unsupported Function

Malformed File