Reading and Writing Parquet Files

Examples Read a single Parquet file: SELECT * FROM 'test.parquet'; Figure out which columns/types are in a Parquet file: DESCRIBE SELECT * FROM 'test.parquet'; Create a table from a Parquet file: CREATE TABLE test AS SELECT * FROM 'test.parquet'; If the file does not end in .parquet, use the read_parquet function: SELECT * FROM read_parquet('test.parq'); Use list parameter to read three Parquet files and treat them as a single table: SELECT * FROM read_parquet(['file1.parquet', 'file2.parquet', 'file3.parquet']); Read all files that match the glob pattern: SELECT * FROM 'test/*.parquet'; Read all files that match the glob pattern, and include the filename…