Downloading sample data
The airline's data is already available in CDW (Hue), but the passenger data is not. Download the sample data for this exercise provided with this pattern.
Airlines data (available in CDP)
Passenger data (to be downloaded)
The passenger data is present in the following CSV file: passengertickets.csv. You will create a “unique_tickets” table from the CSV file by importing it in Hue.
SQL queries for this exercise (to be downloaded)
The following file contains the SQL queries that you will use for this exercise: sample-queries.txt