Parquet Data Analysis
Query remote Parquet files in-browser with DuckDB WebAssembly — no server required.
Data Source
SQL Query
Use
{SOURCE} as a placeholder for the Parquet URL above.
Common functions
SELECT * FROM 'url'— read directly from Parquet URLCOUNT(*)— total record countDESCRIBE SELECT * FROM 'url'— column informationWHERE col = value— filter recordsORDER BY col DESC— sort resultsGROUP BY col— aggregate groupsLIMIT n— cap row count
Hive partitioning tips
- Partition pruning:
WHERE model_name = 'WRF-NARR_HIS' - Cross-model:
GROUP BY model_name - URL pattern:
model_name%3DWRF-NARR_HISencodes=
Query Results
Run a query to see results here.