Module 10 · Enterprise Data Exchange · 10A
Medallion Data Studio
How does a listing become a published gold record?
Try this
- 1Select listing velvet:mist:0
- 2Follow it Bronze → Silver → Gold
- Expected: Same IDs and batch appear in each layer with record counts reconciled.
Pipeline (visual simulation of a lakehouse-style medallion; local data only)
Bronze → Silver → Gold
Delivery reconciliation
raw 4,050 − duplicates/failed = silver 4,029 ✓Follow listing
bronze sample · lineage via batch_id BAT-25-AE-01
Populated table
| batch_id | BAT-25-AE-01 |
| run_id | RUN-1025 |
| listing_key | velvet:mist:0 |
| raw_title | Velvet Orchard Peony Blush Body Mist 250ml |
| raw_title_ar | معطر الجسم فاوانيا بلش 250 مل |
| raw_price_text | AED 99 |
| raw_promo_text | NOW AED 79 |
| captured_at | W/E 22 Aug 2026 03:12 |
| evidence_id | EVD-AE-velvet-mist-0-25 |
Sample SQL
SELECT * FROM bronze.raw_listings WHERE batch_id = 'BAT-25-AE-01' AND listing_key = 'velvet:mist:0';
Schema
batch_id: string run_id: string listing_key: string raw_title: string raw_title_ar: string raw_price_text: string raw_promo_text: string captured_at: string evidence_id: string