Functions/Files & tables/read_parquet

Files & tables Table

read_parquet()

Arguments & returns

2 overloads

`read_parquet(col0, named arguments)`

Table

Overload link	`col0`	Returns
#01	`VARCHAR`	`TABLE`
#02	`VARCHAR[]`	`TABLE`

Named arguments

Pass these after positional arguments, using name := value.

Argument	Type
`binary_as_string :=`	`BOOLEAN`
`can_have_nan :=`	`BOOLEAN`
`compression :=`	`VARCHAR`
`debug_use_openssl :=`	`BOOLEAN`
`encryption_config :=`	`ANY`
`explicit_cardinality :=`	`UBIGINT`
`file_row_number :=`	`BOOLEAN`
`filename :=`	`ANY`
`hive_partitioning :=`	`BOOLEAN`
`hive_types :=`	`ANY`
`hive_types_autocast :=`	`BOOLEAN`
`parquet_version :=`	`VARCHAR`
`schema :=`	`ANY`
`union_by_name :=`	`BOOLEAN`

Example

COPY (SELECT 'apples' AS fruit, 12 AS quantity)
TO 'harvest.parquet' (FORMAT PARQUET);

SELECT * FROM read_parquet('harvest.parquet');

Haybarn WASM 1.5.5-rc3 · In your browser

Guide example · Run to view results.

Available in Haybarn 1.5 DuckDB 1.5 DuckDB 1.4 DuckDB 1.3