Skip to main content

Querying Parquet Files

To run a query directly on a Parquet file, use the read_parquet function in the FROM clause of a query.

Query
SELECT * FROM read_parquet('input.parquet');
Result
 id | name  | value----+-------+-------  1 | alpha |    10  2 | beta  |    20

The Parquet file will be processed in parallel. Filters will be automatically pushed down into the Parquet scan, and only the relevant columns will be read automatically.