Question

A retail analytics team has a medallion pipeline. Raw clickstream and sales events land in bronze, and cleaned, deduplicated, and conformed records are stored in silver. The BI team now needs a table that provides daily revenue by product category and region, pre-aggregated so their dashboards load quickly without scanning millions of rows. Which layer should this new table be created in, and why?

Accepted Answer

The gold layer, because it holds business-level aggregates and curated data optimized for reporting and analytics consumption

Answer

The silver layer, because all business logic and aggregations must live alongside the cleaned data

Answer

The bronze layer, because aggregations should be computed as close to the raw source as possible

Answer

A separate non-Delta external table, because aggregated results should not use Delta Lake format