Writing Data to Amazon S3

You can use MotherDuck to transform files on Amazon S3 or export data from MotherDuck to Amazon S3.

note

MotherDuck supports several cloud storage providers, including Azure, Google Cloud and Cloudflare R2.

MotherDuck supports the DuckDB dialect to write data to Amazon S3. MotherDuck will write data in Parquet format.

Syntax

COPY <table name> TO 's3://<bucket>/[<path>]/<file name>';

Example usage

COPY ducks_table to 's3://ducks_bucket/ducks.parquet'