This page shares details on some of the less visible functionality of ParquetViewer tailored to power users.
Column Formatting
It is possible to control how ParquetViewer renders some data types.
Date / DateTime
By default, datetime values are rendered in the user's local format. However, you can globally control the format used for both rendering and exporting via the Edit → Date Format options. See: User Settings for more details.
Float / Double
By right-clicking on the header of a column of this type you will be presented with two rendering options:
- Scientific (Default)
- Decimal
Scientific rendering is the more accurate and default option. But decimal rendering can be useful for readability when dealing with very small/large fractions:
| Scientific Notation | Decimal Notation |
|---|---|
|
|
|
Note: Unlike date format changes, this formatting change won't affect file exports.
Binary Data
By default, binary data will be rendered in hexadecimal digits: A0-B1-C2-.... However by right-clicking the header of such a column users can select from a list of different rendering options.
The three default options are:
- Hex (Default)
- Base64
- Size
Note: Unlike date format changes, this formatting change won't affect file exports.
Middle-Click Image Peek
If a Struct field conforms to the HuggingFace image format you may middle-mouse click on the field to directly quick peek at the image, skipping the step to open the Struct itself first.
HuggingFace Image Format:
{
"bytes": ...
"path": ...
}
Example:
Freezing Columns
If the horizontal scroll bar is visible you may right-click on the header of any column to freeze it and all columns before it. This allows those columns to always be visible when horizontally scrolling within the main grid of ParquetViewer.
Example:
It's worth noting that columns can be re-arranged by dragging and dropping them.