After reading this blog, I began to wonder which Parquet version and compression methods the everyday tools we rely on actually use, only to find that there's no straightforward way to determine this. That curiosity and the difficulty of quickly discovering such details motivated me to create iparq (Information Parquet). My goal with iparq is to help users easily identify the specifics of the Parquet files generated by different engines, making it clear which features—like newer encodings or certain compression algorithms—the creator of the parquet is using.
New Bloom filters information: Displays if there are bloom filters. Read more about bloom filters in this great article.
-
Make sure to have Astral's UV installed by following the steps here:
-
Execute the following command:
uvx --refresh iparq inspect yourparquet.parquet
-
Install the package using pip:
pip install iparq
-
Verify the installation by running:
iparq --help
-
Make sure to have Astral's UV installed by following the steps here:
-
Execute the following command:
uv pip install iparq
-
Verify the installation by running:
iparq --help
-
Run the following:
brew tap MiguelElGallo/tap https://github.com/MiguelElGallo//homebrew-iparq.git brew install MiguelElGallo/tap/iparq iparq --help
iparq now supports additional options:
iparq inspect <filename> [OPTIONS]Options include:
--format,-f: Output format, eitherrich(default) orjson--metadata-only,-m: Show only file metadata without column details--column,-c: Filter results to show only a specific column
Examples:
# Output in JSON format
iparq inspect yourfile.parquet --format json
# Show only metadata
iparq inspect yourfile.parquet --metadata-only
# Filter to show only a specific column
iparq inspect yourfile.parquet --column column_nameReplace <filename> with the path to your .parquet file. The utility will read the metadata of the file and print the compression codecs used in the parquet file.
ParquetMetaModel(
created_by='DuckDB version v1.2.1 (build 8e52ec4395)',
num_columns=1,
num_rows=100000000,
num_row_groups=10,
format_version='1.0',
serialized_size=1196
)
Parquet Column Information
┏━━━━━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━┳━━━━━━━━━━━━━┳━━━━━━━━━━━━━━┓
┃ Row Group ┃ Column Name ┃ Index ┃ Compression ┃ Bloom Filter ┃
┡━━━━━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━╇━━━━━━━━━━━━━╇━━━━━━━━━━━━━━┩
│ 0 │ r │ 0 │ SNAPPY │ ✅ │
│ 1 │ r │ 0 │ SNAPPY │ ✅ │
│ 2 │ r │ 0 │ SNAPPY │ ✅ │
│ 3 │ r │ 0 │ SNAPPY │ ✅ │
│ 4 │ r │ 0 │ SNAPPY │ ✅ │
│ 5 │ r │ 0 │ SNAPPY │ ✅ │
│ 6 │ r │ 0 │ SNAPPY │ ✅ │
│ 7 │ r │ 0 │ SNAPPY │ ✅ │
│ 8 │ r │ 0 │ SNAPPY │ ✅ │
│ 9 │ r │ 0 │ SNAPPY │ ✅ │
└───────────┴─────────────┴───────┴─────────────┴──────────────┘
Compression codecs: {'SNAPPY'}