Google BigQuery
Connect Telmai to Google BigQuery.
Telmai reads tables and views from BigQuery datasets with a Google Cloud service account.
Before you connect
Choose the service account Telmai uses:
Tenant service account: Telmai's own service account, on GCP deployments only. To see it, start a Google BigQuery connection and select Use tenant service account. The form shows it next to Using service account:.
Your own service account: create a service account key in JSON format.
On hybrid deployments, the account that reads your data is the service account in your hybrid agent, so grant the roles to that account.
Grant the service account these roles:
On each dataset Telmai reads:
BigQuery Data Viewer(roles/bigquery.dataViewer) andBigQuery Metadata Viewer(roles/bigquery.metadataViewer). In the Google Cloud console, open the dataset and click Sharing > Permissions > Add principal. See Grant access to a dataset.On the project where the queries run:
BigQuery Job User(roles/bigquery.jobUser).
Connection fields
On the Connections page, click Add connection and choose Google BigQuery. See Add a connection for the full flow.
Google project
The Google Cloud project that holds the datasets, for example your-project.
Use dataset project for job
Optional, GCP deployments only. Runs BigQuery jobs in the dataset's project.
Use service account credentials or Use tenant service account
GCP deployments only. Choose whether Telmai signs in with your own service account or the tenant service account.
Client email, Client ID, Project ID, Private key ID, Private key
Your own service account's details, from its JSON key. Click Import credentials to fill them in from the JSON file.
On deployments outside GCP, there is no choice under Credentials: fill in your own service account's details.
Asset fields
Click Add assets on the connection. See Add assets.
Dataset
The BigQuery dataset that holds the tables, for example sales.
Limitations
Additional permissions for GCP VPC deployments
On a GCP VPC deployment, Telmai's scan job runs as the service account on the connection. With the tenant service account, there is nothing more to grant. With your own service account, the job also writes its results, so grant that account:
Write scan output and metrics
The Telmai tenant GCS bucket for your deployment
Storage Object Admin (roles/storage.objectAdmin)
Run scan jobs
The GCP project where Telmai runs the scan
BigQuery Job User (roles/bigquery.jobUser)
Ask your Telmai deployment owner for the tenant GCS bucket name and the project the scan runs in.
Last updated