Skip to main content

Dynamic Transformation

This section walks you through migrating your dbt Core project into a fully streamlined data pipeline. Here is how it works: you’ll move your dbt Core project to Snowflake, and DataOps.live provides pipeline capabilities (CI/CD, orchestration, and more) to those dbt models within Snowflake.

The Dynamic Transformation platform manages the automatic migration for you, ensuring a smooth transition. Plus, you gain access to DataOps.live Develop, a browser-based development environment where you can innovate and test your models with the help of a personal AI Assistant.

Step 1. Define the target project in Snowflake

  1. Start typing the name of an existing DataOps group to display a list of options. The group is contained within your customer account and has projects and subgroups.

  2. Enter a name for the new project.

  3. Enter the login information for the Snowflake account where you want to execute the dbt project and click Connect.

  4. Once you see the successful connection message, click Continue.

    Target project !!shadow!!

Step 2. Select the source dbt project

  1. Upload or drop a zip folder of the dbt project you want to migrate. A message will appear to confirm the upload, indicating the number of files.

    Provide the source dbt project you want to migrate !!shadow!!

  2. Once you see the successful upload message, click Continue.

Step 3. Define the target database for your model

  1. From the database list in the Snowflake account, select a database and click Continue.

    Select the target database !!shadow!!

  2. From the confirmation window, do one of the following:

    • Click Open Develop to launch our browser-based development environment and start development on the dbt project.
    • Click Open Project to open the pipeline on the DataOps.live platform.

    Confirmation window !!shadow!!