Parquet

Read a single Parquet file:

SELECT *
FROM 'my_file.parquet';

Read multiple Parquet files as a single table:

SELECT *
FROM read_parquet(['file1.parquet', 'file2.parquet']);

Read all Parquet files that match the glob pattern:

SELECT *
FROM 'my_files/*.parquet';

Write the results of a query to a Parquet file:

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