Introduction When implementing with the medallion architecture in a Lakehouse setup, I often see this pattern: Bronze table: Raw data is continuously appended Silver table: SCD Type 1 processing, retaining only the latest data for each ID. Gold table: Aggregated business data.