Five Second Demo

This query computes the top US airports by total number of inbound flights in 2008, as well as the change from 2008 to 2009:

The source dataset is available on Splitgraph. Despite it containing over 3.6 million rows, this query completes in milliseconds, thanks to a combination of Splitgraph's columnar storage and query result caching.

Run the query from the CLI

You can submit a query to the Splitgraph HTTP API from the command line. If you have curl and jq installed on your system, run this:

jq -Rs '{sql: .}' <<EOF \
    | curl https://data.splitgraph.com/sql/query/ddn \
         -H 'Content-Type: application/json' \
         -d @- \
    | jq '.rows'
SELECT
    destination_airport,
    sum(flights) FILTER (WHERE fly_month BETWEEN '2008-01-01' AND '2009-01-01') AS flights_2008,
    sum(flights) FILTER (WHERE fly_month BETWEEN '2009-01-01' AND '2010-01-01') AS flights_2009
FROM "splitgraph/domestic_us_flights:latest"."flights"
GROUP BY 1 ORDER BY flights_2008 DESC NULLS LAST
LIMIT 5;
EOF