Explore the databases and airline tables

Use Hue to look up existing databases, tables, and data that is available in your data warehouse.

  1. Log in to Hue with your credentials.
  2. Explore the databases and airline tables from the left-assist panel.
  3. Run the following query to get a list of international flights:
    -- Query to find all international flights: flights where destination airport country is not the same as origin airport country
    SELECT DISTINCT 
       flightnum, 
       uniquecarrier, 
       origin, 
       dest, 
       month, 
       dayofmonth, 
       `dayofweek`
    FROM 
       `airline_ontime_orc`.flights f, 
       `airline_ontime_orc`.airports oa, 
       `airline_ontime_orc`.airports da  
    WHERE 
       f.origin = oa.iata 
       and f.dest = da.iata 
       And oa.country <> da.country 
    ORDER BY
       month ASC, 
       dayofmonth ASC  
    ;