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)
The airline data consists of the following four tables:
airlines
airports
flights
planes
The airline data looks as
follows:
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
