1. What is the exact responsibility of Bronze, Silver, and Gold layers in a Medallion Architecture?
Bronze stores raw, immutable append-only source payloads plus ingestion metadata (_ingested_at, _source_file) for full audit replay. Silver deduplicates, casts strict schemas, resolves SCD changes, and quarantines bad records. Gold serves business-ready star schemas, KPI aggregations, and ML/RAG feature tables optimized for BI and API latency.