News for hackers. Stuff that matters.
Re:Introducing dbt + Materialize by jldlaughlin on Monday March 01, 2021 @05:00PM (#26309028)
We (I work at Materialize) actually do support updates! Our CDC sources support them, as well as any source using an UPSERT envelope (more info here: https://materialize.com/docs/sql/create-source/text-kafka/#u...).

As per your second point, I have a less awkward way for you! Materialize supports a top-k idiom (https://materialize.com/docs/sql/idioms/#top-k-by-group) that is hopefully a bit more clear.

Re:Introducing dbt + Materialize by glogla on Monday March 01, 2021 @05:25PM (#26309298)
Right, I saw no update in the SQL keyword list, and saw some (I guess old now) talk about Materialize where the speaker mentioned no updates, sorry!
Re:Introducing dbt + Materialize by jldlaughlin on Monday March 01, 2021 @05:31PM (#26309371)
No apologies necessary, we're an active work in progress! (And, hopefully, moving quickly!)