⌘+k
ctrl+k
Outdated documentation
1.0
1.1 (stable)
1.0
Search Shortcut
cmd
+
k
|
ctrl
+
k
Installation
Documentation
Getting Started
Connect
Overview
Concurrency
Data Import
Overview
CSV Files
Overview
Auto Detection
Reading Faulty CSV Files
Tips
JSON Files
Overview
Multiple Files
Overview
Combining Schemas
Parquet Files
Overview
Metadata
Encryption
Tips
Partitioning
Hive Partitioning
Partitioned Writes
Appender
INSERT Statements
Client APIs
Overview
C
Overview
Startup
Configuration
Query
Data Chunks
Vectors
Values
Types
Prepared Statements
Appender
Table Functions
Replacement Scans
API Reference
C++
CLI
Overview
Arguments
Dot Commands
Output Formats
Editing
Autocomplete
Syntax Highlighting
Go
Java
Julia
Node.js
Overview
API Reference
Python
Overview
Data Ingestion
Conversion between DuckDB and Python
DB API
Relational API
Function API
Types API
Expression API
Spark API
API Reference
Known Python Issues
R
Rust
Swift
Wasm
Overview
Instantiation
Data Ingestion
Query
Extensions
ADBC
ODBC
Overview
Linux Setup
Windows Setup
macOS Setup
Configuration
SQL
Introduction
Statements
Overview
ANALYZE
ALTER TABLE
ALTER VIEW
ATTACH/DETACH
CALL
CHECKPOINT
COMMENT ON
COPY
CREATE INDEX
CREATE MACRO
CREATE SCHEMA
CREATE SECRET
CREATE SEQUENCE
CREATE TABLE
CREATE VIEW
CREATE TYPE
DELETE
DESCRIBE
DROP
EXPORT/IMPORT DATABASE
INSERT
PIVOT
Profiling
SELECT
SET/RESET
SUMMARIZE
Transaction Management
UNPIVOT
UPDATE
USE
VACUUM
Query Syntax
SELECT
FROM & JOIN
WHERE
GROUP BY
GROUPING SETS
HAVING
ORDER BY
LIMIT and OFFSET
SAMPLE
Unnesting
WITH
WINDOW
QUALIFY
VALUES
FILTER
Set Operations
Prepared Statements
Data Types
Overview
Array
Bitstring
Blob
Boolean
Date
Enum
Interval
List
Literal Types
Map
NULL Values
Numeric
Struct
Text
Time
Timestamp
Time Zones
Union
Typecasting
Expressions
Overview
CASE Statement
Casting
Collations
Comparisons
IN Operator
Logical Operators
Star Expression
Subqueries
Functions
Overview
Aggregate Functions
Array Functions
Bitstring Functions
Blob Functions
Date Format Functions
Date Functions
Date Part Functions
Enum Functions
Interval Functions
Lambda Functions
List Functions
Map Functions
Nested Functions
Numeric Functions
Pattern Matching
Regular Expressions
Struct Functions
Text Functions
Time Functions
Timestamp Functions
Timestamp with Time Zone Functions
Union Functions
Utility Functions
Window Functions
Constraints
Indexes
Meta Queries
Information Schema
Metadata Functions
DuckDB's SQL Dialect
Overview
Friendly SQL
Keywords and Identifiers
Order Preservation
PostgreSQL Compatibility
Samples
Configuration
Overview
Pragmas
Secrets Manager
Extensions
Overview
Core Extensions
Community Extensions
Working with Extensions
Versioning of Extensions
Arrow
AutoComplete
AWS
Azure
Delta
Excel
Full Text Search
httpfs (HTTP and S3)
Overview
HTTP(S) Support
Hugging Face
S3 API Support
Legacy Authentication Scheme for S3 API
Iceberg
ICU
inet
jemalloc
JSON
MySQL
PostgreSQL
Spatial
SQLite
Substrait
TPC-DS
TPC-H
VSS
Guides
Overview
Data Viewers
Tableau
CLI Charting with YouPlot
Database Integration
Overview
MySQL Import
PostgreSQL Import
SQLite Import
File Formats
Overview
CSV Import
CSV Export
Directly Reading Files
Excel Import
Excel Export
JSON Import
JSON Export
Parquet Import
Parquet Export
Querying Parquet Files
Network & Cloud Storage
Overview
HTTP Parquet Import
S3 Parquet Import
S3 Parquet Export
S3 Iceberg Import
S3 Express One
GCS Import
Cloudflare R2 Import
DuckDB over HTTPS/S3
Meta Queries
Describe Table
EXPLAIN: Inspect Query Plans
EXPLAIN ANALYZE: Profile Queries
List Tables
Summarize
DuckDB Environment
ODBC
ODBC Guide
Performance
Overview
Import
Schema
Indexing
Environment
File Formats
How to Tune Workloads
My Workload Is Slow
Benchmarks
Python
Installation
Executing SQL
Jupyter Notebooks
SQL on Pandas
Import from Pandas
Export to Pandas
Import from Numpy
Export to Numpy
SQL on Arrow
Import from Arrow
Export to Arrow
Relational API on Pandas
Multiple Python Threads
Integration with Ibis
Integration with Polars
Using fsspec Filesystems
SQL Editors
DBeaver SQL IDE
SQL Features
AsOf Join
Full-Text Search
Snippets
Create Synthetic Data
Glossary of Terms
Browse Offline
Operations Manual
Overview
Limits
Non-Deterministic Behavior
DuckDB's Footprint
Files Created by DuckDB
Gitignore for DuckDB
Securing DuckDB
Overview
Securing Extensions
Development
DuckDB Repositories
Testing
Overview
sqllogictest Introduction
Writing Tests
Debugging
Result Verification
Persistent Testing
Loops
Multiple Connections
Catch
Profiling
Release Calendar
Building
Overview
Build Instructions
Build Configuration
Building Extensions
Supported Platforms
Troubleshooting
Benchmark Suite
Internals
Overview
Storage Versions & Format
Execution Format
Sitemap
Why DuckDB
Media
FAQ
Code of Conduct
Live Demo
Documentation
Sitemap
Installation
Documentation
Getting Started
Connect
Overview
Concurrency
Data Import
Overview
CSV Files
Overview
Auto Detection
Reading Faulty CSV Files
Tips
JSON Files
Overview
Multiple Files
Overview
Combining Schemas
Parquet Files
Overview
Metadata
Encryption
Tips
Partitioning
Hive Partitioning
Partitioned Writes
Appender
INSERT Statements
Client APIs
Overview
C
Overview
Startup
Configuration
Query
Data Chunks
Vectors
Values
Types
Prepared Statements
Appender
Table Functions
Replacement Scans
API Reference
C++
CLI
Overview
Arguments
Dot Commands
Output Formats
Editing
Autocomplete
Syntax Highlighting
Go
Java
Julia
Node.js
Overview
API Reference
Python
Overview
Data Ingestion
Conversion between DuckDB and Python
DB API
Relational API
Function API
Types API
Expression API
Spark API
API Reference
Known Python Issues
R
Rust
Swift
Wasm
Overview
Instantiation
Data Ingestion
Query
Extensions
ADBC
ODBC
Overview
Linux Setup
Windows Setup
macOS Setup
Configuration
SQL
Introduction
Statements
Overview
ANALYZE
ALTER TABLE
ALTER VIEW
ATTACH/DETACH
CALL
CHECKPOINT
COMMENT ON
COPY
CREATE INDEX
CREATE MACRO
CREATE SCHEMA
CREATE SECRET
CREATE SEQUENCE
CREATE TABLE
CREATE VIEW
CREATE TYPE
DELETE
DESCRIBE
DROP
EXPORT/IMPORT DATABASE
INSERT
PIVOT
Profiling
SELECT
SET/RESET
SUMMARIZE
Transaction Management
UNPIVOT
UPDATE
USE
VACUUM
Query Syntax
SELECT
FROM & JOIN
WHERE
GROUP BY
GROUPING SETS
HAVING
ORDER BY
LIMIT and OFFSET
SAMPLE
Unnesting
WITH
WINDOW
QUALIFY
VALUES
FILTER
Set Operations
Prepared Statements
Data Types
Overview
Array
Bitstring
Blob
Boolean
Date
Enum
Interval
List
Literal Types
Map
NULL Values
Numeric
Struct
Text
Time
Timestamp
Time Zones
Union
Typecasting
Expressions
Overview
CASE Statement
Casting
Collations
Comparisons
IN Operator
Logical Operators
Star Expression
Subqueries
Functions
Overview
Aggregate Functions
Array Functions
Bitstring Functions
Blob Functions
Date Format Functions
Date Functions
Date Part Functions
Enum Functions
Interval Functions
Lambda Functions
List Functions
Map Functions
Nested Functions
Numeric Functions
Pattern Matching
Regular Expressions
Struct Functions
Text Functions
Time Functions
Timestamp Functions
Timestamp with Time Zone Functions
Union Functions
Utility Functions
Window Functions
Constraints
Indexes
Meta Queries
Information Schema
Metadata Functions
DuckDB's SQL Dialect
Overview
Friendly SQL
Keywords and Identifiers
Order Preservation
PostgreSQL Compatibility
Samples
Configuration
Overview
Pragmas
Secrets Manager
Extensions
Overview
Core Extensions
Community Extensions
Working with Extensions
Versioning of Extensions
Arrow
AutoComplete
AWS
Azure
Delta
Excel
Full Text Search
httpfs (HTTP and S3)
Overview
HTTP(S) Support
Hugging Face
S3 API Support
Legacy Authentication Scheme for S3 API
Iceberg
ICU
inet
jemalloc
JSON
MySQL
PostgreSQL
Spatial
SQLite
Substrait
TPC-DS
TPC-H
VSS
Guides
Overview
Data Viewers
Tableau
CLI Charting with YouPlot
Database Integration
Overview
MySQL Import
PostgreSQL Import
SQLite Import
File Formats
Overview
CSV Import
CSV Export
Directly Reading Files
Excel Import
Excel Export
JSON Import
JSON Export
Parquet Import
Parquet Export
Querying Parquet Files
Network & Cloud Storage
Overview
HTTP Parquet Import
S3 Parquet Import
S3 Parquet Export
S3 Iceberg Import
S3 Express One
GCS Import
Cloudflare R2 Import
DuckDB over HTTPS/S3
Meta Queries
Describe Table
EXPLAIN: Inspect Query Plans
EXPLAIN ANALYZE: Profile Queries
List Tables
Summarize
DuckDB Environment
ODBC
ODBC Guide
Performance
Overview
Import
Schema
Indexing
Environment
File Formats
How to Tune Workloads
My Workload Is Slow
Benchmarks
Python
Installation
Executing SQL
Jupyter Notebooks
SQL on Pandas
Import from Pandas
Export to Pandas
Import from Numpy
Export to Numpy
SQL on Arrow
Import from Arrow
Export to Arrow
Relational API on Pandas
Multiple Python Threads
Integration with Ibis
Integration with Polars
Using fsspec Filesystems
SQL Editors
DBeaver SQL IDE
SQL Features
AsOf Join
Full-Text Search
Snippets
Create Synthetic Data
Glossary of Terms
Browse Offline
Operations Manual
Overview
Limits
Non-Deterministic Behavior
DuckDB's Footprint
Files Created by DuckDB
Gitignore for DuckDB
Securing DuckDB
Overview
Securing Extensions
Development
DuckDB Repositories
Testing
Overview
sqllogictest Introduction
Writing Tests
Debugging
Result Verification
Persistent Testing
Loops
Multiple Connections
Catch
Profiling
Release Calendar
Building
Overview
Build Instructions
Build Configuration
Building Extensions
Supported Platforms
Troubleshooting
Benchmark Suite
Internals
Overview
Storage Versions & Format
Execution Format
Sitemap
Why DuckDB
Media
FAQ
Code of Conduct
Live Demo
About this page
Report content issue
Edit this page on GitHub