Skip to content
#

scd2

Here are 96 public repositories matching this topic...

Fortune-500-grade banking analytics platform: OLTP -> medallion lakehouse -> Kimball star schema -> semantic layer -> 9-tab executive dashboard + 5 ML models (churn, fraud, segmentation, forecasting). Production-ready, governed, fully tested.

  • Updated Apr 30, 2026
  • Python

Modern data stack reference: dbt + BigQuery + Airflow (Cloud Composer) with medallion layering, SCD2 snapshots, exposures, freshness SLAs, and 45× cost reduction via partition + cluster + incremental tuning.

  • Updated Apr 23, 2026
  • Python

Convention-aware integrity auditor for SCD Type 2 dimensions. 16 SQL checks covering overlaps, gaps, current-flag drift, sentinel drift and point-in-time referential breaks, with findings ranked by the fact rows and revenue at risk and idempotent repair SQL in DuckDB and Snowflake via sqlglot. 1.28M version rows audited in 3.95s.

  • Updated Aug 3, 2026
  • Python

Production-style data platform for an invoice-factoring company: Postgres/MongoDB → Databricks (Spark + Delta) medallion pipeline with data contracts, quarantine and SCD2 → Snowflake (Snowpipe, streams/tasks, dbt marts) orchestrated by Airflow. Includes Terraform, CI, pytest + behave tests, and ADRs.

  • Updated Nov 6, 2026
  • Python

Batch medallion lakehouse: raw -> bronze/silver Delta (delta-rs) -> dbt gold star schema with a full SCD2 customer dimension and point-in-time fact resolution. Great Expectations guards each layer and a reconciler proves gold equals silver in dollars. Ships Spark jobs, an Airflow DAG, and Terraform.

  • Updated Jul 8, 2026
  • Python

Read-only temporal-integrity validator for SCD Type 2 dimensions. Runs seven DuckDB window-function checks (overlaps, gaps, multiple current rows, and more) and reports each violation's blast radius in keys, fact rows, and dollars.

  • Updated Jul 8, 2026
  • Python

Add this topic to your repo

To associate your repository with the scd2 topic, visit your repo's landing page and select "manage topics."

Learn more