nayaread
HomeFavouritesTopicsSources
HomeFavouritesTopicsSources
NayaRead links to original engineering blogs. All copyright belongs to the respective authors.
Shopify Engineering·Aug 27, 2020·13 min read52

How to Track State with Type 2 Dimensional Models - Shopify

In this post, I’ll show how you can create Type 2 dimensional models using modern ETL tooling like PySpark and dbt (data build tool).

Data Engineering
Read original on shopify.engineering

Score breakdown

  • Technical depth81
  • Practical value45
  • Originality85
  • Writing quality100
  • Source reputation0
  • Recency0
  • External engagement0
  • On-site engagement0

NayaRead shows a summary and links to the original article. The full article is hosted on shopify.engineering.

More like this

Shopify Engineering

Double Entry Transition Tables: How We Track State Changes At Shopify - Shopify

May 18, 2022·10 min read
Shopify Engineering

Changing a polymorphic_type in Rails - Shopify

Feb 18, 2022·9 min read
Shopify Engineering

The Complex Data Models Behind Shopify's Tax Insights Feature - Shopify

Feb 8, 2023·13 min read
Shopify Engineering

The generative recommender behind Shopify's commerce engine (2026) - Shopify

Feb 25, 2026·10 min read