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
Vontive uses Materialize + dbt to power live loan underwriting models. They moved their SQL models directly into Materialize without rewrites, cutting loan determination times to half a second.
"The plug-and-play functionality of Materialize was a huge deal for us. We were able to move all our SQL models over to Materialize instantly, without having to rewrite them."
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.