CI/CD workflows for dbt+Materialize

A presentation at Materialize Tech Demo by Marta Paes

Remember how you used to test SQL changes in production? Inspired by Slim CI in dbt Cloud, we’ve been working on tooling to make dbt deployments more ergonomic in Materialize, from project linting to spinning up testing environments.

In this demo, we’ll walk through setting up a CI/CD workflow for a dbt+Materialize project using GitHub Actions, and discuss the unique challenges of automating tests and deployments against a streaming database.

Video

Resources

The following resources were mentioned during the presentation or are useful additional information.