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

What this post added

Introduced and detailed the implementation of double entry transition tables for tracking state changes of multiple entities simultaneously. This involves creating individual attribute tables for each entity's status, merging them, and then transforming them into a double entry format with a `net_change` column. This approach simplifies historical counting and analysis of product usage, such as tracking Shopify Balance account status alongside Shopify account status, and allows for easier scaling with additional attributes without rewriting existing SQL or PySpark jobs.