How xcaim04/cuadre works
Ruta Cobrada reconciles cash-on-delivery activity to show courier debt and explain cash discrepancies. Its main workflow loads daily sources into bronze, transforms them through silver into gold, checks quality, then publishes Parquet for BI. The repository also offers a BigQuery/Dataform implementation. The graph preserves documented stages and capabilities; several SQL and BI details are described in the README but their implementation files were not sampled, so those links rely on README evidence.
Main entry points: pipeline.py Pipeline runner · gold Gold marts · cargar_bigquery.py BigQuery loader · definitions Dataform models
Components 17
Local pipeline
- Synthetic data generator
generar/generar_datos.py - Pipeline runner
pipeline.py - Bronze ingestion
pipeline.py - Bronze tables
pipeline.py - DuckDB store
pipeline.py
Data modeling
- Silver transforms
sql/silver - Gold marts
sql/gold - Quality checks
sql/calidad
BigQuery pipeline
- BigQuery loader
cargar_bigquery.py - BigQuery bronze
dataform/definitions/bronze/fuentes.js - Dataform models
dataform/definitions - BigQuery gold
dataform/definitions/gold
Reporting
- Published Parquet
- Evidence BI
bi/pages/index.md
Other components
- Daily source files
- Cloud Storage
- Finance user
Connections 20
- Synthetic data generator → Daily source files: generates
README.md - Daily source files → Bronze ingestion: loads
README.md - Pipeline runner → Bronze ingestion: loads files
pipeline.py - Bronze ingestion → Bronze tables: writes
pipeline.py - Pipeline runner → Silver transforms: materializes
pipeline.py - Pipeline runner → Gold marts: materializes
pipeline.py - Bronze tables → Silver transforms: transforms
README.md - Silver transforms → Gold marts: feeds
README.md - Pipeline runner → Quality checks: runs checks
pipeline.py - Quality checks → Gold marts: validates
README.md - Pipeline runner → Published Parquet: publishes
pipeline.py - Gold marts → Published Parquet: exports
README.md - BigQuery loader → Daily source files: prepares
cargar_bigquery.py - BigQuery loader → BigQuery bronze: loads tables
README.md - BigQuery loader → Cloud Storage: uploads optionally
cargar_bigquery.py - BigQuery bronze → Dataform models: transforms
README.md - Dataform models → BigQuery gold: builds
README.md - Dataform models → Quality checks: asserts rules
README.md - Published Parquet → Evidence BI: feeds
README.md - Finance user → Evidence BI: views reports
README.md