Parquet Viewer
View, query and analyze Parquet files with SQL
Drop your file here or click to browse
Accepted formats: .parquet • Max size: 100MB
About Parquet Viewer - SQL Query & Analytics Tool
1What is it?
Advanced Parquet file viewer with SQL query capabilities powered by DuckDB-WASM. View, explore, filter, and analyze Parquet files entirely in your browser. Features include: virtualized table viewer for large datasets (millions of rows), full SQL console with autocomplete, column filtering, sorting, and data transformation. Perfect for data engineers and analysts working with columnar data formats. All processing is 100% client-side - your data never leaves your device.
2Use Cases
- Explore Parquet files without installing Python or Spark
- Query large datasets with SQL (JOINs, GROUP BY, aggregations)
- Filter and analyze data lake exports directly in browser
- Preview Parquet schema and sample data before processing
- Run ad-hoc analytics on Parquet files without a database
- Validate data quality and structure before ETL pipelines
3Examples
Large File Viewing
Input
sales_data.parquet (100MB, 2M rows)
Output
Virtualized table view
SQL Analytics
Input
SELECT category, SUM(amount) FROM data GROUP BY category
Output
Aggregated results
Data Filtering
Input
Filter: amount > 1000 AND region = 'US'
Output
Filtered table
?Frequently Asked Questions
How does SQL querying work without a database?
We use DuckDB-WASM, a high-performance analytical SQL database that runs entirely in your browser using WebAssembly. It's the same engine used by data engineers for big data analytics, but compiled to run client-side. It supports full SQL syntax including JOINs, CTEs, window functions, and complex aggregations.
Can it handle very large Parquet files?
Yes! The viewer uses a virtualized table that only renders visible rows, so you can smoothly browse files with millions of rows. For files up to 100MB (our max), the viewer loads and indexes the data efficiently. SQL queries are optimized by DuckDB's query planner for fast execution.
What SQL features are supported?
DuckDB supports nearly all standard SQL features: SELECT, WHERE, JOIN (INNER, LEFT, RIGHT, FULL), GROUP BY, HAVING, ORDER BY, window functions (ROW_NUMBER, RANK, LAG, LEAD), CTEs (WITH), subqueries, aggregations (SUM, AVG, COUNT, MIN, MAX, STDDEV), and 100+ built-in functions. It's more powerful than SQLite for analytics.
Is my data safe?
Absolutely! ALL processing happens in your browser. Your Parquet files are never uploaded to any server. You can disconnect from the internet after loading the page and the tool will still work. This makes it perfect for sensitive financial data, healthcare records, or confidential business information.
Can I export query results?
Yes! After running a SQL query, you can export the results as CSV, JSON, or Excel. Simply run your query, then use the download button to save the filtered/transformed data in your preferred format.