Parquet Export

To export the data from a table to a Parquet file, use the COPY statement:

Query

COPY tbl TO 'output.parquet' (FORMAT parquet);

The result of queries can also be directly exported to a Parquet file:

Query

COPY (SELECT * FROM tbl) TO 'output.parquet' (FORMAT parquet);

The flags for setting compression, row group size, etc. are listed in the Reading and Writing Parquet files page.