Queries on Local Files
In the chDB and DuckDB databases, you can easily query local files with SQL. You can query CSV, JSON, Parquet & more.
Drag-and-drop a file into the SQL query editor, and run queries on the file right away. This is great for quick ad-hoc queries.
If you don’t want to write queries by hand, consider to instead attach the file as a source (currently possible with chDB connections only). This allows you to use the AI Assistant and the data explorer UI for your file.
When you drag-and-drop a file into an empty query editor, the editor will be populated with a default query to select from your file:
Alternatively, if the editor is not empty, only the file’s identifier will be inserted at the cursor position:
Learn More
To learn more on how to query files with chDB/ClickHouse, or with DuckDB:
- See the documentation of ClickHouse’s
file()function - Or see DuckDB’s documentation: CSV, JSON, Parquet, Excel