The last tier of the medallion architecture, where refined tables ready for the business live, for example aggregates and star schemas that feed reports and analytics.
Read more: Microsoft Learn
In the Ultra Transcenders books
Each book explains Gold layer in context, with comparison tables and the common traps.
Terms in this definition
- LAST
Restricted to visual calculations, this DAX function reads a value from the final position along one of the visual's axes. Writing INDEX(-1) gives the same result.
- 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.
- Medallion architecture
Organises a lakehouse in three tiers: Bronze keeps what landed untouched, Silver keeps it cleaned up and conformed, and Gold keeps business-ready aggregates for reporting.
- WHERE
Limits a SELECT, UPDATE or DELETE to just the rows meeting a condition. Omit it, and the statement hits every row.
- RAMP
The approach used by the Cloud Adoption Framework's Manage methodology to structure cloud operations: teams, duties, processes and tools. It divides what the central platform handles from what each workload handles.
- Azure Artifacts feed
Holds packages (Cargo, Universal, Python, Maven, npm, NuGet) in Artifacts; it belongs to a project or the organisation and supports views, feed roles and upstreams.