Self-Service Exploratory AnalyticsPDF version

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.

The airline data consists of the following four tables:
  • airlines
  • airports
  • flights
  • planes
The airline data looks as follows:


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.

The following file contains the SQL queries that you will use for this exercise: sample-queries.txt