dbt + Materialize: dbt workflows for operational data
Use dbt to manage operational data transformations on Materialize. Version control, test, and deploy SQL models that stay fresh with strong consistency guarantees.
From transformations to data products
Define SQL transformations with dbt, then deploy as live views and data products with Materialize.
dbt
Version-controlled SQL transformations with testing and documentation
Materialize
Live views and data products that stay fresh as source data changes
How Materialize integrates with dbt
Maintain the entire schema of your SQL transformations (sources, views, materialized views) in a dbt project in a git repo.
Execute dbt run from the CLI to build the SQL models and transformations in Materialize once, and to migrate after updates.
Materialize runs SQL transformations as live views and data products. Results can be queried in SQL or streamed out.
Trusted by engineering and data teams
Pluralsight uses Materialize + dbt to simplify their streaming data architecture. They migrated Spark and Flink jobs to Materialize's SQL interface, managing transformations through dbt for easier deployment and faster iteration.
"We have been able to move some of our Spark and Flink jobs over into Materialize and have found them easier to manage...as well as quicker to build."
Start building with dbt + Materialize
Deploy Materialize as a managed service or run it anywhere. Use your existing dbt project to build live views and data products in minutes.