Skip to content
#

referential-integrity

Here are 23 public repositories matching this topic...

Structured data-cleaning pipeline built on the Olist e-commerce dataset, focusing on reproducible ingestion, schema profiling, and light standardization using Python and pandas. Emphasizes clear pipeline stages, auditability, and portfolio-ready documentation.

  • Updated Apr 3, 2026
  • Python

PostgreSQL sales-analytics warehouse consolidating CRM and ERP CSV extracts into a star-schema reporting layer. Medallion architecture (Bronze → Silver → Gold) with data-quality rules, deduplication, and gold views (dim_customers, dim_products, fact_sales).

  • Updated Apr 4, 2026

Profile a real warehouse, ship only a 156 KB JSON profile, regenerate it elsewhere. Referentially complete synthetic data from a schema plus a profile, using a Gaussian copula for correlation, labelled defect injection and byte-identical output from a seed. 101 SQL integrity checks, worst per-column KS 0.057, zero exact source matches.

  • Updated Aug 3, 2026
  • Python

Improve this page

Add a description, image, and links to the referential-integrity topic page so that developers can more easily learn about it.

Curate this topic

Add this topic to your repo

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

Learn more