.parquet files
.parquet file
Apache Parquet
A columnar binary data format built for analytics on very large tables.
What opens a .parquet file
- Windows
- DuckDB, Tad, ParquetViewer, Python (pandas / pyarrow)
- macOS
- DuckDB, Tad, Python (pandas / pyarrow)
- Linux
- DuckDB, Tad, Python (pandas / pyarrow)
What a .parquet file is
Parquet stores tables column by column with per-column compression, so a query that touches three fields of a hundred never reads the rest — the reason data warehouses and Spark, DuckDB and pandas pipelines standardised on it. Files are binary and self-describing, carrying their own schema. Nothing opens one by double-clicking: DuckDB, the Tad desktop viewer or a few lines of Python are the usual routes.
Converting it
A .parquet file is commonly converted to .csv, .json, .arrow or .xlsx. It is a binary format, so a text editor will show unreadable characters rather than its contents.
Details
- Extension
- .parquet
- Full name
- Apache Parquet
- Category
- Data
- MIME type
- application/vnd.apache.parquet
- Created by
- Apache Software Foundation
- Format
- Binary
Common questions
- How do I open a .parquet file?
- On Windows use DuckDB; on macOS use DuckDB; on Linux use DuckDB. A columnar binary data format built for analytics on very large tables.
- What is a .parquet file?
- Apache Parquet. Parquet stores tables column by column with per-column compression, so a query that touches three fields of a hundred never reads the rest — the reason data warehouses and Spark, DuckDB and pandas pipelines standardised on it. Files are binary and self-describing, carrying their own schema.
- Can I convert a .parquet file?
- Yes. It is usually converted to .csv, .json, .arrow or .xlsx, either by exporting from one of the programs listed above or with a format converter.
Related pages
- .csv — Comma-Separated Values A spreadsheet as plain text, one row per line — the universal data exchange form
- .json — JavaScript Object Notation The standard text format for structured data on the web and in config files.
- .xml — Extensible Markup Language A tag-based text format for structured data, still everywhere in enterprise syst
- .yaml — YAML Data File An indentation-based configuration format, readable but unforgiving about whites
- .log — Log File A plain-text record of what a program did, newest events usually at the bottom.
- .torrent — BitTorrent Metainfo File A few kilobytes of metadata describing what to download and from whom — not the
- .dat — Generic Data File A meaningless extension — .dat says only that some program stored data here.
- .vcf — vCard Contact File One or more contacts as plain text — the standard way to move an address book.
- .sql — SQL Script A text file of database commands — often a full database dump.
- .ics — iCalendar Event A calendar invitation or event feed in a plain-text standard format.
- .sqlite — SQLite Database A complete relational database in a single file — the most deployed database in
- .db — Generic Database File An extension many programs use for their data — it does not identify one format.
Sources
- Media Types Registry — IANA
- Official vendor product documentation — At One Place