Data Engineering Weekly
Data Engineering Weekly
DEW #131: dbt model contract, Instacart ads modularization in LakeHouse Architecture, Jira to automate Glue tables, Server-Side Tracking

DEW #131: dbt model contract, Instacart ads modularization in LakeHouse Architecture, Jira to automate Glue tables, Server-Side Tracking

Conversation with Aswin about Data Engineering Weekly Edition #131

Welcome to another episode of Data Engineering Weekly. Aswin and I select 3 to 4 articles from each edition of Data Engineering Weekly and discuss them from the author’s and our perspectives.

On DEW #131, we selected the following article

Ramon Marrero: DBT Model Contracts - Importance and Pitfalls

dbt introduces model contract with 1.5 release. There were a few critics of the dbt model implementation, such as The False Promise of dbt Contracts. I found the argument made in the false promise of the dbt contract surprising, especially the below comments.

As a model owner, if I change the columns or types in the SQL, it's usually intentional. - My immediate no reaction was, Hmm, Not really.

However, as with any initial system iteration, the dbt model contract implementation has pros and cons. I’m sure it will evolve as the adoption increases. The author did an amazing job writing a balanced view of dbt model contract.

Instacart: How Instacart Ads Modularized Data Pipelines With Lakehouse Architecture and Spark

Instacart writes about its journey of building its ads measurement platform. A couple of thing stands out for me in the blog.

  1. The Event store is moving from S3/ parquet storage to DeltaLake storage—a sign of LakeHouse format adoption across the board.

  2. Instacart adoption of Databricks ecosystem along with Snowflake.

  3. The move to rewrite SQL into a composable Spark SQL pipeline for better readability and testing.

Timo Dechau: The extensive guide for Server-Side Tracking

The blog is an excellent overview of server-side event tracking. The author highlights how the event tracking is always close to the UI flow than the business flow and all the possible things wrong with frontend event tracking. A must-read article if you’re passionate about event tracking like me.

the hipster data stack
The extensive guide for Server-Side Tracking
I would love to learn if more people had a server-side awakening event. Mine was over six years. It was not my first time sending events from a backend, and I did this in projects before, mostly sending refund events to Google Analytics. But this time, it was a paradigm shift and a good example of why developers should always play a core and active role …
Read more

Credit Saison: Using Jira to Automate Updations and Additions of Glue Tables

This Schema change could’ve been a JIRA ticket!!!

I found the article excellent workflow automation on top of the familiar ticketing system, JIRA. The blog narrates the challenges with Glue Crawler and how selectively applying the db changes management using JIRA help to overcome its technical debt of running 6+ hours custom crawler.