File Formats

Load data into MotherDuck using various file formats.

📄️ Apache Iceberg

MotherDuck supports querying data in the Apache Iceberg format. The Iceberg DuckDB extension is loaded automatically when any of the supported Iceberg functions are called.

📄️ Delta Lake

MotherDuck supports querying data in the Delta Lake format. The Delta DuckDB extension is loaded automatically when any of the supported Delta Lake functions are called.

📄️ DuckLake

In us-east-1, MotherDuck is compatible from client versions . In eu-central-1, MotherDuck is compatible from client version . Preview features may be operationally incomplete and may offer limited backward compatibility.

🔗 CSV

Comma-separated values (CSV) is a simple text-based format for tabular data.

🔗 JSON

JSON (JavaScript Object Notation) is a lightweight data-interchange format.

🔗 Parquet

Apache Parquet is a columnar storage file format optimized for analytics.