SQL Query Tool

How to use the SQL Query Tool

1. Click "+ Add File" and choose one or more files, or drag them onto the My Files panel. CSV, TSV, Parquet, JSON, NDJSON, Arrow, Excel (.xlsx or .xls, first sheet) and YAML are supported.
2. Each file becomes a table named after its filename, so orders.csv becomes orders. Characters other than letters, digits and underscores become underscores. Click a table in the list to see its columns and types.
3. Write a query in the SQL editor, or open the Builder to pick columns, filters, sort order and a row limit without typing.
4. Click Run Query or press Ctrl+Enter (Cmd+Enter on a Mac). Results appear below the editor.
5. Download the result as CSV or JSON. To work with public data instead of your own files, open the Data Catalog tab and load a dataset into the editor.

Worked example

You have two exports: a customer list and an order list. You want total spend per customer, largest first.

Input: customers.csv and orders.csv, then the query

customers.csv
customer_id,name,country
1,Ana,PT
2,Ben,NZ
3,Chloe,FR

orders.csv
order_id,customer_id,amount
101,1,40
102,3,25
103,1,15
104,2,60

SELECT c.name, COUNT(*) AS orders, SUM(o.amount) AS total
FROM orders o
JOIN customers c ON o.customer_id = c.customer_id
GROUP BY c.name
ORDER BY total DESC;

Result

name   orders  total
Ben    1       60
Ana    2       55
Chloe  1       25

The two files are joined on customer_id like two database tables. Ana has two orders (40 + 15 = 55), so she appears once with a count of 2. Ben has the single largest order and comes first.