BigdataSight 1.2 · Direct and Mac App Store

Supported sources

The sources BigdataSight can open, including where preview, SQL, and export boundaries differ.

Viewer supports local Parquet and CSV with up to two tabs. Every remote source and every other supported local format requires Pro. See the pricing comparison.

On your Mac

Local files and table roots

Parquet

Viewer

Supported

Schema, row-group metadata, paging, filters, read-only SQL, and current-page CSV export. Pro adds full export scopes and formats.

CSV

Viewer

Supported

Schema, paging, filters, read-only SQL, and current-page CSV export. Pro adds full export scopes and formats.

TSV

Pro

Supported

Local preview, paging, read-only SQL, and source export.

JSON / NDJSON / JSONL

Pro

Supported

Schema, preview, paging, read-only SQL, and source export.

SQLite

Pro

Supported

Table selection, schema, preview, filters, read-only SQL (including ORDER BY), and export.

Excel (.xlsx)

Pro

Workbench: preview and export

Sheet selection, schema, preview, filters, and source export. The workbench has no SQL view or sorting control; BigdataSight 1.2 command-line and AI queries support selected worksheets.

Arrow IPC / Feather

Pro

Workbench: preview and export

Schema, paging, profile, and source export. The workbench has no SQL view or cross-source query; BigdataSight 1.2 command-line and AI SQL support these inputs.

Delta / Iceberg table roots

Pro

Supported

Local table-root discovery, preview, read-only SQL, and export.

Pro

Remote objects and lakehouse tables

S3 Parquet

Pro

Metadata-first schema and preview, range reads, read-only SQL, export, and workspace restore.

S3 CSV

Pro

Preview, read-only SQL, export, and workspace restore through a configured S3 connection.

S3 Delta / Iceberg table roots

Pro

Metadata-first discovery, preview, read-only SQL, export, and workspace restore.

AWS Glue Iceberg REST

Pro

Iceberg table discovery through the Glue REST endpoint, followed by the supported S3 table-root workflow.

BigdataSight 1.2

Command-line and AI workflows

In BigdataSight 1.2, choose files or folders and an access level in Settings → External Access. Viewer supports local Parquet and CSV. Pro also supports TSV, JSON/NDJSON/JSONL, SQLite, Excel, Arrow/Feather, and current local Delta/Iceberg table directories.

Command-line and AI queries support selected Excel worksheets and Arrow/Feather inputs even though these formats do not have a SQL view in the workbench. SQLite queries can use up to eight selected tables or views from SQLite databases; mixing SQLite with other formats is unavailable.

With Pro, use supported S3 sources and saved REST or AWS Glue REST selections for SQL, comparison, export, and context. Explicit remote Delta versions and Iceberg snapshots are supported where the operation offers version selection. Local table queries use the current state.

These workflows are available in both editions. Follow the setup guide to install the command line or connect your AI client.

Not advertised as supported

Unavailable sources and operations

Avro and ORC cannot currently be opened in either tier.
Remote single-file JSON, Avro, Arrow IPC, and Feather are not supported.
Hive Metastore and provider-specific Glue Data Catalog attachment are not supported.
Deep governance semantics for Unity Catalog, Nessie, and Polaris are not supported.

Purchasing Pro unlocks supported Pro capabilities; it does not turn an unavailable source into a supported one. Review known limitations before purchasing.