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

DuckLake is in preview and requires DuckDB version 1.3.1 or greater. The file format and related metadata structure are subject to change. Consider your workload requirements carefully and test thoroughly before using with important data.

🔗 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.