Postgres + Docker SQL analytics lab with data quality checks, performance EXPLAIN notes, and CI.
docker sql postgresql data-quality github-actions analytics-engineering dimensional-modeling sql-optimization
-
Updated
Feb 9, 2026 - PLpgSQL
#
dimensional-modeling
Here are 3 public repositories matching this topic...
Language: PLpgSQL
Filter by language
Production-style SQL analytical platform built in PostgreSQL using layered architecture (stg - core - marts) with strict integrity enforcement and revenue reconciliation validation.
sql etl data-validation postgresql data-warehouse data-modeling analytics-engineering dimensional-modeling
-
Updated
Feb 23, 2026 - PLpgSQL
Production-style SCD Type 1 data pipeline built with Snowflake and AWS S3, featuring automated ingestion via Snowpipe, change detection with Streams, and conditional orchestration using Tasks and stored procedures. Demonstrates warehouse-native ELT and dimensional modeling best practices.
aws snowflake data-engineering data-pipeline dimensional-modeling snowpipe scd-type-1 snowflake-tasks snowflake-streams
-
Updated
Jan 4, 2026 - PLpgSQL
Improve this page
Add a description, image, and links to the dimensional-modeling topic page so that developers can more easily learn about it.
Add this topic to your repo
To associate your repository with the dimensional-modeling topic, visit your repo's landing page and select "manage topics."