Introducing dbt + Materialize

Re:Introducing dbt + Materialize by andrenotgiant on Monday March 01, 2021 @02:18PM (#26306937)

Relevant related post: A data pipeline is just a materialized view: https://nchammas.com/writing/data-pipeline-materialized-view

[ Parent | on HN ]

Re:Introducing dbt + Materialize by jldlaughlin on Monday March 01, 2021 @03:24PM (#26307900)

Neat! We're totally on the same page--incremental view maintenance not only makes materialized views a useful building block for data pipelines, it can make them much simpler, too!

[ Parent | on HN ]

Re:Introducing dbt + Materialize by sitkack on Monday March 01, 2021 @09:20PM (#26311198)

So it is CTEs all the way down, a bag of dags. A raw table is just a view over the raw data, a cooked view is just a view of views, repeat.

Do you use any of the ideas of Noria? Cadence?

This is great, but at what COST?!

[ Parent | on HN ]

Re:Introducing dbt + Materialize by touisteur on Monday March 01, 2021 @04:42PM (#26308833)

Mmmh I've been thinking a lot about generated/computed fields as I wanted to use them in pg. They were introduced in pg12 but only materialized.

[ Parent | on HN ]