Joining and aggregating retail data
Your team at Global Retail Analytics wants to understand revenue patterns across regions. A new CSV file called country_lookup.csv has been added to the datasets volume, mapping each country to its region and currency.
You'll enrich the online_retail data with this lookup dataset using a broadcast join, verify the query plan, and aggregate revenue by region.
This exercise is part of the course
Data Transformation with Spark SQL in Databricks
Hands-on interactive exercise
Turn theory into action with one of our interactive exercises
Start Exercise