Introducing Integration for dbt

Unlock the Power of dbt on EazyDI Platform

We are excited to introduce dbt (Data Build Tool) integration within our platform, empowering data teams to transform and model data with ease. Whether you're using dbt Cloud or prefer dbt Core, our platform provides seamless support for both, offering flexibility to suit your workflow needs.

Why dbt Integration Matters

dbt enables analytics engineers to transform raw data into valuable insights using SQL-based models, while ensuring version control and collaboration. By integrating dbt into our ETL platform, users can:

• Leverage dbt Cloud for managed transformation workflows.

• Execute dbt Core via post-scripts for on-premise or custom transformation needs.

• Automate and orchestrate dbt models within broader ETL pipelines.

• Ensure data quality, documentation, and governance at every step.

How It Works

1. Using dbt Cloud

For users who prefer a fully managed experience, our ETL platform allows direct integration with dbt Cloud. Simply provide your dbt Cloud API key and project details, and the platform will:

• Trigger dbt transformations as part of ETL workflows.

• Monitor run status and logs.

2. Using dbt Core

For users who prefer self-managed workflows, our platform supports executing dbt Core using post-scripts. This enables:

• Running dbt models locally or on a dedicated environment.

• Custom scheduling and orchestration of transformations.

• Greater control over dependency management and execution.

Key Features

• Flexible Execution: Choose between dbt Cloud or dbt Core based on your operational needs.

• Seamless Orchestration: Integrate dbt transformations within ETL workflows.

• Scalability: Support for large-scale data transformations with optimized performance.

Getting Started

1. For dbt Cloud Users:

   • Create Pipeline

   • Connect your dbt Cloud account via API keys.

   • Define the execution schedule within our ETL platform.

2. For dbt Core Users:

   • Ensure dbt Core is installed in your execution environment.

   • Configure post-scripts to run dbt models after data ingestion.

Conclusion

By integrating dbt into our ETL platform, we are enabling teams to harness the full potential of modern data transformation. Whether you prefer dbt Cloud for simplicity or dbt Core for flexibility, our platform ensures a smooth and powerful experience for all your data transformation needs.

Ready to get started? Reach out to our team or explore the documentation to integrate dbt with your workflows today!

Open