Google BigQuery access share

Select correct project

1. Login into Google Cloud Console (BigQuery). https://console.cloud.google.com/bigquery

2. Select a project which contains datasets. Select the correct project with the top left button.

Create Service Account

1. Navigate to the “Service Account” section and press the “Create service account” button.

2. Fill in required fields and press the “Create and continue” button.

3. Select the required roles (DataViewer, ReadSessionUser, JobUser).

4. Finish account creation.

5. Navigate to the “Manage keys” section of the newly created account.

6. Create new key.

7. Export key as json, downloaded json file is required for Assetario integration.

Sharing BigQuery dataset with Assetario role

1. Create a new dataset for Assetario - it will only be used for materialized views, created by running queries in BigQuery, which will expire once not needed anymore.

2. Fill in required fields and press the “Create dataset” button.

3. Open the newly created dataset.

4. Press the “Share Dataset” button.

5. Fill in service account id and “BigQuery Data Editor” role.

6. Press “Add” to add permissions and check if the service account is added to the “BigQuery Data Editor” section. Press “Done” if the service account is shown in the section.

Sharing BigQuery access with integration@assetario account

1. Open dataset.

2. Press the “Sharing” button and select “Permissions” option.

3. Click on “Add Principal” button.

4. Fill in “[e-mail]” and select “BigQuery Data Viewer” role.

5. To add a write permissions, follow the same process, but choose “BigQuery Data Editor” instead of “BigQuery Data Viewer”.