This page is for DuckDB 1.4 (LTS).
Switch to the latest version
.
⌘K
ctrl+k
1.4
LTS
2.0
LTS
1.5
1.4
LTS
1.3
1.2
1.1
1.0
0.10
Search Shortcut
cmd
+
k
|
ctrl
+
k
Search docs
⌘K
ctrl+k
Installation
Documentation
Documentation
Getting Started
Connect
Overview
Concurrency
Data Import and Export
Overview
Data Sources
CSV Files
Overview
Auto Detection
Reading Faulty CSV Files
Tips
JSON Files
Overview
Creating JSON
Loading JSON
Writing JSON
JSON Type
JSON Functions
Format Settings
Installing and Loading
SQL to / from JSON
Caveats
Multiple Files
Overview
Combining Schemas
Parquet Files
Overview
Metadata
Encryption
Tips
Partitioning
Hive Partitioning
Partitioned Writes
Appender
INSERT Statements
Lakehouse Formats
Client APIs
Overview
Tertiary Clients
ADBC
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
Safe Mode
Autocomplete
Syntax Highlighting
Known Issues
Dart
Go
Java (JDBC)
Overview
Define Connections
Run Queries
Import Data
Handle Results
Define Functions
Profile and Monitor
Troubleshoot
Julia
Node.js (Deprecated)
Overview
API Reference
Node.js (Neo)
Overview
ODBC
Overview
Linux Setup
Windows Setup
macOS Setup
Configuration
PHP
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
Deploying DuckDB-Wasm
Instantiation
Data Ingestion
Query
Extensions
SQL
Introduction
Statements
Overview
ANALYZE
ALTER TABLE
ALTER VIEW
ATTACH and 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 and IMPORT DATABASE
INSERT
LOAD / INSTALL
MERGE INTO
PIVOT
Profiling
SELECT
SET / RESET
SET VARIABLE
SHOW and SHOW DATABASES
SUMMARIZE
Transaction Management
UNPIVOT
UPDATE
USE
VACUUM
Query Syntax
SELECT
FROM and 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 Expression
Casting
Collations
Comparisons
IN Operator
Logical Operators
Star Expression
Subqueries
TRY
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
Indexing
Friendly SQL
Keywords and Identifiers
Order Preservation
PostgreSQL Compatibility
SQL Quirks
Samples
Configuration
Overview
Pragmas
Secrets Manager
Extensions
Overview
Installing Extensions
Advanced Installation Methods
Distributing Extensions
Versioning of Extensions
Troubleshooting of Extensions
Core Extensions
Overview
AutoComplete
Avro
AWS
Azure
Delta
DuckLake
Encodings
Excel
Full Text Search
httpfs (HTTP and S3)
Overview
HTTP(S) Support
Hugging Face
S3 API Support
Legacy Authentication Scheme for S3 API
Iceberg
Overview
Iceberg REST Catalogs
Amazon S3 Tables
Amazon SageMaker Lakehouse (AWS Glue)
Troubleshooting
ICU
inet
jemalloc
Lance
MySQL
PostgreSQL
Spatial
Overview
Function Reference
R-Tree Indexes
GDAL Integration
SQLite
TPC-DS
TPC-H
UI
Unity Catalog
Vortex
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
File Access with the file: Protocol
Network and 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
Fastly Object Storage Import
Tigris Import
Meta Queries
Describe Table
EXPLAIN: Inspect Query Plans
EXPLAIN ANALYZE: Profile Queries
List Tables
Summarize
DuckDB Environment
ODBC
ODBC Guide
Performance
Overview
Environment
Import
Schema
Indexing
Join Operations
File Formats
How to Tune Workloads
My Workload Is Slow
Benchmarks
Working with Huge Databases
Python
Installation
Executing SQL
Jupyter Notebooks
marimo 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
Integration with PyTorch
Using fsspec Filesystems
SQL Editors
DBeaver SQL IDE
SQL Features
AsOf Join
Full-Text Search
Graph Queries
query and query_table Functions
Merge Statement for SCD Type 2
Timestamp Issues
Snippets
Creating Synthetic Data
Dutch Railway Datasets
Sharing Macros
Analyzing a Git Repository
Importing Duckbox Tables
Copying an In-Memory Database to a File
Troubleshooting
Crashes
Out of Memory Errors
Glossary of Terms
Browsing Offline
Operations Manual
Overview
DuckDB's Footprint
Files Created by DuckDB
Gitignore for DuckDB
Reclaiming Space
Installing DuckDB
Requirements
Install Script
Logging
Overview
Securing DuckDB
Overview
Embedding DuckDB
Securing Extensions
Non-Deterministic Behavior
Limits
DuckDB Docker Container
Development
DuckDB Repositories
Release Cycle
Profiling
Building DuckDB
Overview
Build Configuration
Building Extensions
Android
Linux
macOS
Raspberry Pi
Windows
Python
R
Troubleshooting
Unofficial and Unsupported Platforms
Benchmark Suite
Testing
Overview
sqllogictest Introduction
Writing Tests
Debugging
Result Verification
Persistent Testing
Loops
Multiple Connections
Catch
Internals
Overview
Storage Versions and Format
Execution Format
Pivot
Docs
/
Documentation
/
Guides
/
Database Integration
Copy Markdown
Database Integration
Pages in This Section
View Markdown
Edit on GitHub
Report an issue
© 2026 DuckDB Foundation, Amsterdam NL
DuckDB Home
Code of Conduct
Trademark Use
Blog
