Skip to content

DuckDB Analytics Workbench

Analyze CSV, JSON and Parquet in your browser with DuckDB SQL, query plans, charts and guided exercises.

DuckDB

DuckDB-Wasm WebAssembly

Ctrl/⌘ + Enter
Starting DuckDB…

Results

Run a SQL statement to see its result here.

DuckDB terminalBrowser session

Type .help for terminal commands. SQL runs in the current local DuckDB database.

Summarize a CSV or Parquet file with DuckDB SQL

Open Import data / SQL, choose a CSV or Parquet file, and create a table named sales. Check the detected column types in Schema. If the file has category and amount columns, run SELECT category, SUM(amount) AS total FROM sales GROUP BY category ORDER BY total DESC. Change the column names in the query to match your file.

Use the result chart to compare category totals, or export the result as CSV. The workbench processes your file in the browser and accepts data files up to 128 MiB. The first Parquet import can require downloading a DuckDB extension.

Comments

Sign in or create an account to join the discussion.

Loading comments…