1 — ADLS2 Storage

Pre-class Checklist — 2 weeks before

TRAINER ONLY

<span class="trainer-phase-label">2 weeks before</span>
<span class="trainer-step-indicator">Step <strong>1</strong> of 9</span>

2 Weeks Before — Infrastructure

Note

Azure resource group — ADLS2 and Databricks are pre-provisioned together under 1000_data_engineering_workshop (subscription MHP Resort Consulting Services, tenant mhpdev.onmicrosoft.com).

Set this up first — Databricks 00_setup.py and Snowflake external stages depend on the storage account key and SAS token from this page.

Azure / ADLS2 Storage (mhpdeworkshopsa)

Pre-provisioned — account already exists; do not create a new one.

Item	Value
Storage account	mhpdeworkshopsa
Resource group	1000_data_engineering_workshop
Location	Germany West Central
Subscription	MHP Resort Consulting Services (ba826c91-8e52-4e07-ac7c-538858bbc813)
Azure tenant	mhpdev.onmicrosoft.com

• Storage account accessible — open resource group in Azure Portal → click mhpdeworkshopsa
• Container nyc-taxi-data exists (create only if missing)
• TLC data downloaded from NYC TLC Trip Record Data:
  • yellow_tripdata_2024-10.parquet (Yellow Taxi, Parquet — workshop default month)
  • taxi_zone_lookup.csv (Auxiliary / zone lookup table)
• Uploaded to ADLS2 mhpdeworkshopsa / nyc-taxi-data:
  • raw/trips/yellow_tripdata_2024-10.parquet
  • raw/lookup/taxi_zone_lookup.csv (exact filename)
  • Portal Storage Browser → container nyc-taxi-data → upload to paths above
• Container nyc-taxi-data — raw/trips/ Parquet + raw/lookup/taxi_zone_lookup.csv verified in Portal
• Storage account key (Databricks) — Security + networking → Access keys → rotate/copy key1
• SAS token (Snowflake) — container nyc-taxi-data → Generate SAS:
  • Signing method: Account key
  • Permissions: Read + List only
  • Expiry: workshop date + 2 days
  • Copy SAS token query string (save immediately — shown once)
• Verify: Databricks spark.read.parquet(...) works with new key
• Verify: Snowflake LIST @...nyc_taxi_trips_stage returns files with SAS token

---

→ Next 2 — Databricks workspace Needs ADLS2 storage account key