| CARVIEW |
Select Language
HTTP/2 200
date: Sat, 11 Oct 2025 15:56:08 GMT
content-type: text/html; charset=utf-8
server: cloudflare
access-control-allow-origin: *
cache-control: public, max-age=0, must-revalidate
content-disposition: inline
report-to: {"group":"cf-nel","max_age":604800,"endpoints":[{"url":"https://a.nel.cloudflare.com/report/v4?s=OqFM0NB06UYCBIsTETWdBHa088sTp6Y0sTOeiMoRZbe0oN2967cnST%2BIrdL046y8pfTJhIsJ00rUctXY0NPc%2BQla4JgTppTJcFpaCuqpdgInbw%3D%3D"}]}
x-matched-path: /docs/getting-started/five-second-demo
x-vercel-cache: HIT
x-vercel-id: fra1::xl8rq-1760198168184-3c22e938c8d8
vary: Accept-Encoding
x-varnish: 4816898
age: 247672
via: 1.1 varnish (Varnish/6.5)
x-cache: MISS
nel: {"report_to":"cf-nel","success_fraction":0.0,"max_age":604800}
strict-transport-security: max-age=63072000
cf-cache-status: DYNAMIC
content-encoding: gzip
cf-ray: 98cf8bb21cf2a6bb-BOM
alt-svc: h3=":443"; ma=86400
Five Second Demo | Splitgraph 
Splitgraph has been acquired by EDB! Read the blog post.
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
Table of contents
Splitgraph
Splitgraph Inc, registered in Delaware, USA
Splitgraph Limited, registered in England and Wales No. 11657324
Made with
on four continents.