DuckDB Analytics Workbench
Analyze CSV, JSON and Parquet in your browser with DuckDB SQL, query plans, charts and guided exercises.
DuckDB
DuckDB-Wasm WebAssembly
Results
Run a SQL statement to see its result here.
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…