Finish Slime #26

Data Engineering, Analytics. No ML, no AI. The weekly dose of the data content you actually want to read!

Want to share anything with me? Hit me up on Twitter @sbalnojan, LinkedIn, or Instagram.

Great Recent Stuff

Announcing Malloy 4.0

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.

Dimensional Data Modeling with dbt (hands-on)

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.

Brickflow

This tool is an interesting framework from Nike to develop Databricks data flows in Python, coupled with a CLI for ease of use.

Upsert in SQL

The ugly upsert operation in SQL; explained and explored in detail.

5 reasons to use machine learning for improved data quality

CapitalOne makes a good case for the use of automated data quality solutions. They even published an open-source framework to help called DataProfiler.

These 8 Articles Changed How I See Data Engineering

Some data engineering articles are so profound they stand out over the years; these are eight of those.

I dreamt we spoke again

This is just a fun article coupled with the video of the talk on “The Return of Analytics Engineering.” It's a good watch.