rdt-model-store

rdt-model-store generates and deploys all Snowflake storage artifacts across the medallion architecture:

• Bronze — Physical append-only table with G1 completeness checks
• Silver — Curated view with G2 validity filters, enriched from RTiS terminologies + Collibra governance
• Gold — Data product view with G3 + G4 business rules, enriched from all sources
• Semantic — Semantic view definition for Cortex Analyst and AI-queryable metrics

All DDL and dbt models are generated from Tera templates embedded at compile time.

Pipeline phase: Phase 4 — Deploy

Usage:

cargo run -p rdt-model-store -- --target dev generate --entity waste-tracking --dry-run
cargo run -p rdt-model-store -- --target dev deploy --entity waste-tracking

Configuration:

Key	Source	Description
snowflake.account	roche-data.toml	Snowflake account identifier
SNOWFLAKE_USER	Environment variable	Snowflake username
SNOWFLAKE_PRIVATE_KEY	Environment variable	Key-pair authentication

Dependencies:

• rdt-model-pull (model.json)
• rdt-model-govern (governance.json, gupri.yaml)

Output:

File	Format	Description
snowflake/ddl/{entity}.sql	SQL	Bronze DDL + G1 DQ rules
dbt/models/bronze/{entity}.sql + .yml	SQL/YAML	dbt Bronze model + schema
dbt/models/silver/{entity}_silver.sql + .yml	SQL/YAML	dbt Silver view + G2 tests
dbt/models/gold/{entity}_gold.sql + .yml	SQL/YAML	dbt Gold view + G3 tests
dbt/models/semantic/{entity}.semantic.yml	YAML	Semantic view for Cortex Analyst

Access gate: Blocked until access tasks A05 + A06 (Snowflake) resolve. Generates artifacts locally in --dry-run mode until then.

DQ integration: G2 and G3 quality predicates in Silver/Gold views are compiled separately by rdt-model-policy from the shared CEL rule library. See Quality Assurance Approach for the full four-gate architecture.