BigQuery
Connect a Google BigQuery dataset to DashX. Once installed, you can sync its tables into Resources and query them through the DashX API.
Prerequisites
Prerequisites
Before setting up the BigQuery integration, ensure you have:
- An active DashX account
- A Google Cloud project with billing enabled
- The BigQuery API enabled on that project
- A dataset you want to expose to DashX
Create a service account
BigQuery authenticates with a service account key.
- Open the Google Cloud Console and select your project
- Go to IAM & Admin > Service Accounts and click Create service account
- Give it a name (e.g.
dashx-bigquery) and create it - Grant it these roles:
- BigQuery Data Viewer — read table data
- BigQuery Job User — run queries
- Open the service account, go to the Keys tab
- Click Add key > Create new key, choose JSON, and download the file
warning
The downloaded JSON is a credential. Store it securely and do not commit it to source control.
Connect to DashX
- Log in to your DashX workspace
- Navigate to Settings > Integrations
- Click [+] to add a new integration and select BigQuery
- Choose the environments you want to enable it for
- Enter the configuration below and save
Configuration
| Field | Description |
|---|---|
| Credentials | The full contents of the service account JSON key file. The project is read from the key. |
Sync your tables
With the integration installed, open Data > Overview and choose Sync Database to read the schema and turn tables into resources. See Resources for the full flow.
tip
BigQuery bills by bytes scanned. Prefer partitioned and clustered tables, and grant access only to the datasets DashX actually needs.
Related: the Database Hub app.