Databases
Apache Arrow File Viewer in VS Code
Overview
Section titled “Overview”DBCode lets you open and work with Apache Arrow (IPC) files directly in VS Code. Browse data with sorting and filtering, and run SQL queries against your Arrow files using DuckDB under the hood.
Features
Section titled “Features”- Open any
.arrowfile in the data grid - Sort, filter, and group data
- Run SQL queries against Arrow data
- View schema information
- View the custom metadata embedded in the file
- Export to other formats (CSV, Excel, Parquet, JSON)
File metadata
Section titled “File metadata”Arrow files can carry custom metadata on their schema. Expand a table in the connection tree and open its Metadata node to see it. Your own keys show at the top, and tooling-written keys such as ARROW:schema are tucked under a collapsed System group. Hover a value to read it in full, right-click to copy it, or click a long value to open it in an editor.
Compression support
Section titled “Compression support”Arrow IPC file and stream formats are supported, including uncompressed and ZSTD-compressed files. LZ4-compressed Arrow files cannot be read; re-save them uncompressed, with ZSTD, or as Parquet.