Skip to main content
When you create an Alteryx bundle for a SQL project in the Prophecy transpiler, you can analyze, change, and validate your migration before the transpilation begins.

​
Limitations

Review the supported versions and migration scope:
  • Prophecy supports transpiling files from Alteryx Designer version 2023.2 and later.
  • Prophecy cannot migrate Alteryx schedules. You must manually configure your schedule in your Prophecy project after you transpile your Alteryx workflow. Then, you can monitor your schedule on the Monitoring page.

​
Prerequisites

To migrate workflows from Alteryx to Prophecy, you need to:
  • Ensure that the Alteryx Transpiler is enabled in your Prophecy environment.
  • Export the Alteryx workflows that you want to migrate as files. Prophecy accepts .xml, .yxmd, .yxwz, and .yxmc files. For more information on these file types, visit Alteryx File Types in the Alteryx documentation.

​
Differences between Databricks and BigQuery import

The SQL dialect generated during import depends on the selected fabric:
  • Databricks fabric → Databricks SQL
  • BigQuery fabric → BigQuery SQL
You cannot change the SQL dialect after transpilation without recreating the bundle. While the migration workflow is the same, some behaviors differ depending on the selected fabric:
  • SQL syntax: Generated SQL follows the target engine (Databricks or BigQuery).
  • Tool support: Some Alteryx tools may map differently depending on engine capabilities.

​
Procedure

1

Create a bundle

Start with creating a new Import bundle.
  1. On the left navigation bar, click the Import icon (arrow pointing down in a circle).
  2. At the top of the page, click Import Bundle.
  3. In the Source Type tab, select Alteryx.
  4. Click Next.
  5. In the Bundle Details tab, fill out the following fields:
    FieldAction
    Import Bundle NameProvide a name for the bundle.
    LanguageSelect SQL as the primary code language.
    TeamCreate or select the team that will be able to access the bundle.
    ProjectCreate or select the project where Prophecy will add migrated pipelines.
    The project you choose must have the same language and team defined in the bundle.
    BranchSelect the Git branch where the migration will appear.
    The Transpiler will not commit directly to the main branch of the project repository.
    SQL FabricChoose the fabric that determines the SQL dialect and execution engine for your migrated pipelines.

    - Select a Databricks fabric to generate Databricks SQL.
    - Select a BigQuery fabric to generate BigQuery SQL.
  6. Click Next.
  7. In the Upload Files tab, upload the Alteryx files you want to migrate. Prophecy accepts .xml, .yxmd, .yxwz, and .yxmc files.
  8. Click Next. The Transpilation step opens.
2

Configure Import details

Configure how Prophecy imports your workflows.
  1. In the left sidebar under All files, review the files you uploaded.
  2. If necessary, add more files to the bundle by dragging and dropping or browsing your local file system.
  3. To stage a file for transpilation, click on the file. The file appears under Entities for Transpilation.
  4. For each pipeline that you stage:
    • Review the Source Mapping File to verify the original file that corresponds to the new pipeline.
    • Verify or change the Target Pipeline Name, which will be the name of your new Prophecy pipeline.
    • Check the Entities associated with this pipeline section to see the datasets that will be created.
    • Enable the Transpile interface tools into configurations checkbox if you want to convert interface tools from Alteryx into pipeline configurations in Prophecy.
  5. Click Validate to have Prophecy check that the migration is possible for all staged files.
  6. Once validation passes, click Transpile to begin the actual conversion process. The Transpile button is only enabled after successful validation. Import workflows
Once you add a pipeline or table to the bundle, you can disable the import by deselecting the relevant checkbox. Disabling the import is useful if you want to save the pipeline or table in the import configuration to import it at a later time.
3

Import transpiled entities

Import the transpiled entities into your project.
  1. After you click Transpile, the Choose entities to create dialog opens.
  2. Review a list of entities that the transpiler has detected.
  3. Disable entities that you do not want to migrate, if needed.
  4. Click Import > Import.
  5. Click View Bundle Details. Reimport
4

Review Prophecy project

Verify and adjust transformations as needed. If there isn’t an equivalent gem for a certain transformation, Prophecy inserts a placeholder gem in your pipeline where you can write your own SQL statements to achieve the required functionality.

​
Step 5: Review bundle metadata

After you successfully import a bundle, you see the Imported status on the Transpiler page.To see the bundle metadata, which includes information about all of the imported entities in the bundle, click on the bundle.ReimportYou can review the pipelines, jobs, tables, function, coverage, status, source, language, project, and fabric of the bundle in the right tile. You can open any entity in a new tab in the project editor by clicking on the entity.
5

Testing

Open your bundle and run your pipeline to verify that it writes the same output as your Alteryx workflow. If not, modify or add additional gems to make the output the same.Before you deploy your project into production, we recommend you to run both your Alteryx workflow and Prophecy pipeline in parallel for at least two weeks. This helps you see if Prophecy consistently produces the same output as Alteryx.

​
Reimport pipelines

If you want to update or restart your transpilation, click on the Reimport Pipeline button on the Transpiler page. Reimport For support, please see Getting help with Prophecy.