ParVuEx - Parquet Viewer Extended

Overview

This application allows you to execute SQL queries on Parquet/CSV files. Uses DuckDB Python implementation.

Extended Version Major Changes

Redesign UI

• Enhanced SQL statement highlighting
  • Support column names highlighting
  • Support common highlighting such as comments, values, strings
  • Customable highlighting keywords
• Add simple status info
  • Showing total/current/selected rows
• Support SQL statement history
  • Use hotkeys to switch previous statements
• Concise main UI
• Simplify pagination
• Improve dialogs
• Auto remember columns width
• Zebra striping for the table

SQL Edit

• Auto complete
• Support inserting specific columns

Statistics

• Value counts
  • Show statistics on selected columns
• Quick row values
  • Show selected row values in a table
• Table info
• Quick highlight characters as you type

Support launcher

• Speedup startup time
  • Use only one core
  • Minimize to tray
• Support single/multi windows

Others

• Add new hotkeys
• Memory efficient (can open a large file quickly)
• Support _.csv, _.parquet

Hotkeys

• Browse SQL statement history
  • Ctrl+↑/↓
• Pagination
  • Ctrl+←/→
• Excute
  • Enter
  • Shift+Enter for new lines
• Mouse scroll the table horizontally
  • Hold Shift

How to Use

1. Click File → Open to select a Parquet/CSV file.
2. Write your SQL query in the provided text area.
3. Click Execute or press Enter to run the query and see results.

Build

• Windows
  • build.bat

FAQ:

1. Which SQL Queries are supported?
   • Basically it supports data transformation, non join queries. Look here

Icon

Table of content icons created by iconsax - Flaticon