Star schema

Tables

SCD2 LAT-001

Queries run at build time

Store revenue

SELECT store_id, SUM(amount_cents) AS revenue_cents FROM fact_sales GROUP BY store_id ORDER BY revenue_cents DESC, store_id LIMIT 5

LAT-001 SCD2 versions

SELECT sku, product_name, price_cents, valid_from, valid_to, is_current FROM dim_product WHERE sku = 'LAT-001' ORDER BY valid_from

Top SKUs

SELECT sku, SUM(amount_cents) AS revenue_cents FROM fact_sales GROUP BY sku ORDER BY revenue_cents DESC, sku LIMIT 5