The guides section contains compact how-to guides that are focused on achieving a single goal. For an in-depth reference see the Documentation section.
DuckDB SQL
SQL: Data Import & Export
CSV Files
Parquet Files
- How to load a Parquet file into a table
- How to export a table to a Parquet file
- How to run a query directly on a Parquet file
JSON Files
Excel Files with the Spatial Extension
HTTP, S3 and GCP
SQL: Meta Queries
- How to list all tables
- How to view the schema of the result of a query
- How to quickly get a feel for a dataset using summarize
- How to view the query plan of a query
- How to profile a query
Python Client
- How to install the Python client
- How to execute SQL queries
- How to easily query DuckDB in Jupyter Notebooks
- How to use Multiple Python Threads with DuckDB
- How to use fsspec filesystems with DuckDB
Pandas
- How to execute SQL on a Pandas DataFrame
- How to create a table from a Pandas DataFrame
- How to export data to a Pandas DataFrame
Apache Arrow
- How to execute SQL on Apache Arrow
- How to create a DuckDB table from Apache Arrow
- How to export data to Apache Arrow
Relational API
Python Library Integrations
- How to use Ibis to query DuckDB with or without SQL
- How to use FugueSQL to use DuckDB with Python/Pandas functions
- How to use DuckDB with Polars DataFrames via Apache Arrow
- How to use DuckDB with Vaex DataFrames via Apache Arrow
- How to use DuckDB with DataFusion via Apache Arrow
SQL Editors / IDE's
- How to set up the DBeaver SQL IDE
- How to use the Harlequin terminal-based SQL IDE
- How to set up Rill Data Developer