Skip to content
SQLSimplified
Data EngineerQuestion 30 of 55

Medallion Architecture Layers

Problem

You are organizing folders in the data lake. You split data into Bronze (raw files), Silver (cleaned and joined tables), and Gold (aggregations for BI reporting). Write a query that outputs concept with the value: "Medallion architecture organizes data into incremental quality layers: Bronze (raw ingestion), Silver (cleaned/enriched), and Gold (aggregated business tables)."

Database Schema

This problem acts as a scratchpad. You will write your own DDL/DML or conceptual queries, so there is no predefined schema.

Try It

Loading playground environment...

Hint

Solution