Finish Slime #26
Malloy, Brickflow and Upserts
Data Engineering, Analytics. No ML, no AI. The weekly dose of the data content you actually want to read!
Great Recent Stuff
Malloy is a simple query language made for analytics. The queries are easy to understand and pragmatic and translate to SQL, optimized for a database.
Everyone needs to know the dimensional model, even if just to decide to do things differently. Madison is an expert on dbt and dimensional modeling and a great guide on this topic.
This tool is an interesting framework from Nike to develop Databricks data flows in Python, coupled with a CLI for ease of use.
The ugly upsert operation in SQL; explained and explored in detail.
CapitalOne makes a good case for the use of automated data quality solutions. They even published an open-source framework to help called DataProfiler.
Some data engineering articles are so profound they stand out over the years; these are eight of those.
This is just a fun article coupled with the video of the talk on “The Return of Analytics Engineering.” It's a good watch.
Exclusive Gifts 🎁
We’ve got a new exclusive gift for you! The dbt reading guide, busting myths and helping you get up to speed quickly! With 20 resources in one doc.
And of course this exclusive gift! Data Engineering Reading Guide - the best books, articles & resources you must read!
More resources from the Finish Slime:
How did you like this edition?