Azure medallion data architecture ingests raw data from on-premises SQL Server and Azure Blob Storage via Azure Data Factory into a three-layer ADLS Gen2 storage account. Bronze, Silver, and Gold layers progressively transform raw unstructured data into cleaned, conformed, and aggregated business-level datasets using Azure Databricks Spark Notebooks. This layered approach enforces data quality governance and enables self-service analytics while maintaining a single source of truth. Fork this diagram on Diagrams.so to customize ingestion sources, add transformation logic, or integrate additional Azure services like Synapse Analytics. The medallion pattern is ideal for organizations modernizing legacy data warehouses while preserving on-premises data sources.