The medallion lakehouse's middle tier, where data has been cleaned and conformed; raw data sits below it in bronze and curated data above it in gold.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Silver layer in context, with comparison tables and the common traps.
Terms in this definition
- Lakehouse
Fabric storage item in OneLake that holds structured and unstructured content side by side: managed Delta tables go under Tables, other files under Files. Spark is used for processing, and a read-only SQL analytics endpoint allows T-SQL queries.
- Archive
Offline access tier for blobs, cheapest to store yet dearest to access. Reading a blob means rehydrating it first, which can take as long as 15 hours.
- WHERE
Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.