Ecosystemdbt + Materialize demo: Running dbt’s jaffle_shop with Materialize

Introduction We’ve recently partnered with dbt and community members to release a beta Materialize dbt adapter that allows you to transform your streaming data in real time using Materialize as your data warehouse. This tutorial serves as a practical hands-on demonstration of the adapter. In this case, we are using static not streaming data, but […]

EcosystemIntroducing: dbt + Materialize

Managing data is hard. Managing data pipelines is even harder. The meaning of individual tables or values in your data warehouse gets lost in translation across organizations. Another team’s refactor breaks your team’s pipeline. And, it’s normally very difficult to tell who made what change and when. dbt, data build tool, alleviates these frustrations by […]

Use CaseWhy Use a Materialized View?

TL;DR: Querying materialized views, unlike querying tables or logical views, can reduce query costs by maintaining results in memory that are only updated when necessary. To learn more, check out the rest of the post! The Cost of Querying Each time you query a database you incur some cost. Your database will parse, validate, plan, […]

About This Blog

Welcome! On our blog, you’ll hear more about the inner workings of Materialize – what we’ve built, what we plan to build, and how it all works together.

New here? Read these