Use dbt to manage Materialize
dbt has become the standard for data transformation (“the T in ELT”). It combines the accessibility of SQL with software engineering best practices, allowing you to not only build reliable data pipelines, but also document, test and version-control them.
Setting up a dbt project with Materialize is similar to setting it up with any other database that requires a non-native adapter.
dbt-materialize
adapter can only be used with dbt Core. Making the
adapter available in dbt Cloud depends on prioritization by dbt Labs. If you
require dbt Cloud support, please reach out to the dbt Labs team.
Available guides
See also
As a tool primarily meant to manage your data model, the dbt-materialize
adapter does not expose all Materialize objects types. If there is a clear
separation between data modeling and infrastructure management ownership
in your team, and you want to manage objects like
clusters, connections, or
secrets as code, we recommend using the Materialize
Terraform provider as a complementary deployment tool.