Skip to content

Instantly share code, notes, and snippets.

@barbietunnie

barbietunnie/read-parquet-with-duckdb.md

Created November 15, 2024 12:39
Show Gist options
  • Save barbietunnie/88f5f87ea36589658eb6662204b51590 to your computer and use it in GitHub Desktop.
Save barbietunnie/88f5f87ea36589658eb6662204b51590 to your computer and use it in GitHub Desktop.
Download ZIP
How to read Parquet files with DuckDB
Raw
read-parquet-with-duckdb.md

How to read Parquet files with DuckDB

  • Create a new DuckDB in-memory connection using DBeaver, specifying the path as :memory:

  • Create a new script to run your query with, using the connection created

    SELECT * FROM parquet_schema('/path/to/parquet/file.parquet');

SELECT * FROM read_parquet('/path/to/parquet/file.parquet');
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment