The guides section contains compact how-to guides that are focused on achieving a single goal. For API references and examples, see the rest of the documentation.
Note that there are many tools using DuckDB, which are not covered in the official guides. To find a list of these tools, check out the Awesome DuckDB repository.
Tip For a short introductory tutorial, check out the “Analyzing Railway Traffic in the Netherlands” tutorial.
Data Import and 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
HTTP(S), S3 and GCP
- Network and cloud storage overview
- How to authenticate to S3 / AWS
- How to load a Parquet file directly from HTTP(S)
- How to load a CSV file directly from HTTP(S)
- How to load a Parquet file directly from S3
- How to export a Parquet file to S3
- How to load a Parquet file from S3 Express One
- How to load a Parquet file directly from GCS
- How to load a Parquet file directly from Cloudflare R2
- How to load a Parquet file directly from Fastly Object Storage
- How to load a Parquet file directly from SeaweedFS
- How to load a Parquet file directly from Tigris
- How to load an Iceberg table directly from S3
- How to connect to Amazon S3 Tables
- How to connect to Amazon SageMaker Lakehouse (AWS Glue)
- How to share a DuckDB database that only stores views
- How to attach to a DuckDB database over HTTPS or S3
JSON Files
Excel Files
Querying Other Database Systems
- Database integration overview
- How to directly query a MySQL database
- How to directly query a PostgreSQL database
- How to directly query a SQLite database
- How to connect to Amazon RDS / Aurora with IAM authentication
Directly Reading Files
Performance
- Performance guide overview
- My workload is slow (troubleshooting guide)
- How to design the schema for optimal performance
- What is the ideal hardware environment for DuckDB
- How to import data efficiently
- How to use indexes and zonemaps
- How to make join operations efficient
- What performance implications do Parquet files and (compressed) CSV files have
- How to tune workloads
- How to avoid out-of-memory issues
- How to work with huge databases
- Benchmarks
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
- How to inspect the DuckDB environment (version, platform, extensions)
ODBC
Python Client
- How to install the Python client
- How to execute SQL queries
- How to easily query DuckDB in Jupyter Notebooks
- How to easily query DuckDB in marimo 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
NumPy
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 DuckDB with Polars DataFrames via Apache Arrow
- How to stream DuckDB query results to PyTorch via Apache Arrow
SQL Features
- Friendly SQL
- As-of join
- Full-text search
- Graph queries
queryandquery_tablefunctions- Merge statement for SCD Type 2
- Timestamp issues
SQL Editors and IDEs
- How to set up the Beekeeper Studio SQL editor
- How to set up the DBeaver SQL IDE
- How to set up the DBine SQL editor
- How to set up the LibreDB Studio SQL editor
- How to set up the VisuaLeaf SQL editor
Data Viewers
- How to visualize DuckDB databases with Tableau
- How to draw command-line plots with DuckDB and YouPlot
Snippets
- Creating synthetic data
- Dutch railway datasets
- Sharing macros
- Analyzing a Git repository
- Importing duckbox tables
- Copying an in-memory database to a file
- Calculating a database checksum
Troubleshooting
Glossary and Offline Docs
関連キーワード
関連するページ
© 2026 DuckDB Foundation, Amsterdam NL