Skip to main content

GCP BigQuery

You can give Sundial Read-Only access to your existing BigQuery Datasets or Tables.

Alternatively you can create a separate BigQuery Dataset to store the tables which you would like to share with Sundial.

Sundial will create a new GCP IAM Service Account for your organisation: We will e-mail you the specific IAM service account, which will be of the format:

<name>@<project-name>.iam.gserviceaccount.com

In IAM give this service account a role BigQuery User

Read-Only Permissions​

Give Read-Only access to your BigQuery Dataset or BigQuery Tables to the Sundial IAM Service Account.

GRANT `roles/bigquery.dataViewer` 
ON SCHEMA `<project_name.dataset_name>` 
TO 'serviceAccount:***<name>@<project-name>.iam.gserviceaccount.com***'

dataset_name.table_name - Is the table you want to give access to Sundial

Write Space (Optional)​

Sundial can store generated Standard Product Metrics into your BigQuery. If this is required, please provide the Sundial Role access to write to a BigQuery Dataset

CREATE SCHEMA `<project_name>.sundial_data`
GRANT `roles/bigquery.dataEditor`
ON SCHEMA `<project_name>.sundial_scratch`
TO 'serviceAccount:***<name>@<project-name>.iam.gserviceaccount.com***'

sundial_data - The dataset created for Sundial with read-write access.

Have questions? Write to bharat@sundial.so and anoop@sundial.so