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

MotherDuck currently supports DuckDB . In US East (N. Virginia) - us-east-1, MotherDuck is compatible with client versions through . In Europe (Frankfurt) - eu-central-1, MotherDuck supports client version through .

CSV

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

Excel

Excel is a spreadsheet file 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.