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)

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