Introducing Flights: agent-native data pipelines in MotherDuckJoin the livestream

Skip to main content

Parquet

Parquet is a columnar file format designed for analytics. DuckDB can query Parquet files directly and persist the result as a MotherDuck table.

How it works with MotherDuck​

  1. Connect to MotherDuck from a DuckDB client.
  2. Point read_parquet at a local file, HTTPS URL, S3 path, or another supported storage location.
  3. Load the result into a MotherDuck table if you need managed storage, access control, or sharing.

Example​

CREATE TABLE my_table AS
SELECT *
FROM read_parquet('s3://my-bucket/path/*.parquet');

Related content​