BigQuery Client
The BigQuery GUI Client for Mac.
A fast, native BigQuery GUI client for Mac. Connect with a service account JSON or gcloud auth. Browse projects, datasets, tables; run Standard SQL with cost estimates; export streaming results. Free and open source.
Features
Built for BigQuery.
Service Account or OAuth
Service account JSON key or gcloud auth application-default login. Tokens in the macOS Keychain.
Dry-Run Cost Estimate
Cmd+Shift+Return shows bytes processed and dollar cost before the query runs.
Standard SQL Editor
Tree-sitter highlighting for BigQuery Standard SQL. Autocomplete for project.dataset.table paths.
Cross-Project Queries
Reference any project you have IAM access to. Full three-part path autocompletes.
Streaming Result Sets
Million-row queries stream from BigQuery. Cancel cleanly. Export streams to disk.
AI SQL Assistant
Ask in English, get BigQuery SQL. Suggest partitioning and clustering for cost reduction.
Data Grid
Browse and edit data.
Sort, filter, and edit BigQuery data in a spreadsheet-like grid. Click any cell to edit. Insert and delete rows. Review changes before saving.
SQL Editor
Write queries faster.
Tree-sitter syntax highlighting, schema-aware autocomplete, multi-tab, Vim mode, and full-text query history. AI assistant can write, explain, or optimize your SQL.
Capabilities
What you can do.
- Browse projects, datasets, tables, views, routines
- Run Standard SQL with cost estimate before execution
- View slot consumption and query plan
- Switch projects and regions with Cmd+K
- Stream-export million-row results
- View partitioned and clustered table metadata
- Full-text search across query history
- Safe mode blocks queries above a cost threshold
Connect
Get connected in seconds.
# Connect with TablePro
Project: my-gcp-project
Auth: Service Account JSON
Key File: ~/.gcp/service-account.json
# Or via bq CLI
bq query --use_legacy_sql=false 'SELECT * FROM `my-gcp-project.dataset.table` LIMIT 10'Supported versions
Google BigQuery (all regions), BigQuery Omni
Connection types
- Service Account JSON
- gcloud Application Default Credentials
- OAuth User Auth
How to
Connect to BigQuery in four steps.
- 1
Install TablePro and the BigQuery plugin
brew install --cask tablepro. Settings > Plugins, install BigQuery from the registry.
- 2
Get a Service Account Key
Google Cloud Console: create a service account with BigQuery User. Download the JSON key.
- 3
Add a BigQuery Connection
Click New Connection. Pick BigQuery. Enter project ID, select the JSON key file.
- 4
Connect
Click Connect. Datasets appear in the sidebar. Cmd+Shift+Return for a dry-run.
FAQ
Common BigQuery questions.
How do I authenticate with BigQuery?
Two paths. Service account JSON key, or gcloud auth application-default login. TablePro picks up the local creds.
Does it show query cost?
Yes. Cmd+Shift+Return for a dry-run that returns bytes and estimated USD.
Can I query across projects?
Yes. Reference any project.dataset.table you have IAM access to. The full path autocompletes.
Does it support BigQuery Omni?
Yes. Omni regions on AWS and Azure work the same as Google Cloud regions.
Is the service account key secure?
Yes. macOS Keychain. Never on disk in plaintext.
Try TablePro for free.
Free and open-source. macOS 14+. Apple Silicon and Intel.