BigdataSight 1.2 · Direct and Mac App Store
Known limitations
Review the source, query, export, and AI connection limits for your version before choosing a workflow.
SQL availability depends on the source
- SQL is read-only.
- The workbench has no SQL views for Excel, Arrow IPC, or Feather. BigdataSight 1.2 command-line and AI queries support selected worksheets and Arrow/Feather inputs.
- BigdataSight 1.2 SQLite queries support up to eight selected tables or views. Mixing SQLite with other formats is unavailable.
- SQL result tabs contain the rows loaded by the query. Exporting a result tab exports those rows without rerunning the query over the full source.
Some source operations are intentionally narrower
- Arrow IPC and Feather source export does not apply grid filters; these inputs also have no sorting control.
- The main grid does not sort from column headers. Use an explicit SQL ORDER BY for sources with a SQL view; Excel has no sorting control.
- Avro and ORC are unavailable. Remote single-file formats are limited to Parquet and CSV.
Export has explicit scope and limits
- Source export supports CSV, JSON, Parquet, Arrow IPC, and Feather. Workbench SQL result tabs export CSV, JSON, and Arrow IPC. BigdataSight 1.2 command-line and AI query exports also support Parquet with compression choices.
- Arrow IPC and Feather source output currently materializes at most 100,000 rows.
- Current page and all rows are the supported source-export scopes; there is no selected-rows-only export.
Remote and catalog support is specific
- Remote access requires Pro and a supported connection. Object-store access uses S3.
- AWS Glue support means the verified Iceberg REST workflow; it does not mean every Glue Data Catalog operation is available.
- Catalog providers and table layouts outside the supported list are unavailable.
AI connections and verification have specific limits
- AI workflows require an external MCP-compatible client that can start a local command on this Mac. Its account, plan, and data-handling settings are managed by its provider.
- Local command-line and AI access uses the files/folders and access level in Settings → External Access.
- File preview operations return at most 50 rows and 20 columns. BigdataSight 1.2 SQL commands return at most 1,000 rows; full query exports have separate limits. Viewer supports Parquet/CSV; other formats and remote sources require Pro.
- Remote verification and Recipe management require Pro. BigdataSight 1.2 SQL, Profile, comparison, and export also require the corresponding source access level. Local Delta/Iceberg queries use current state; local historical queries and snapshot comparison are unavailable.
- Independent tasks require Pro and an awake Mac. They can outlast a client session. After restarting the Mac, check task status before submitting the operation again.
- Offline examples use built-in evidence. Opening a completed report shows the recorded comparison without checking the source again. Inconclusive means the available evidence did not establish the rule.
Distribution channels remain separate
- A Direct license cannot unlock the App Store build, and an App Store purchase cannot generate a Direct license.
- Direct licenses support up to two active Macs. App Store device availability follows Apple account and StoreKit rules.
- Direct checks for a new version at most once per week and links to the official download page. Download and install updates manually.
Check the full supported sources list. If your workflow is not covered clearly, contact support before purchasing Pro.