Tools are located under the 'Tools' menu.

This tool will generate an ANSI SQL 'CREATE TABLE' script matching the schema of the currently loaded parquet file. This is handy if a SQL table is needed that matches the schema of the parquet file.

The script will contain only loaded fields.

This tool will read the Thrift metadata that is stored in every parquet file as well as any additional custom metadata that is found.

Supported metadata are: thrift (default), pandas, arrow:schema. Other metadata will be displayed raw. If you come across custom metadata that is not human readable, feel free to open an issue ticket to see if we can add support for that type of metadata.

This tool provides a way to run DuckDB queries on parquet (and other) files. Simply utilize the DuckDB sql query syntax to perform query operations: https://duckdb.org/docs/stable/data/parquet/overview

Because this tool utilizes DuckDB, its query syntax is different than the query syntax used for Filter Queries. Additionally there is no way to export query results to a file from the query editor at this time.