Google BigQuery

The ETL service loads your daily export into a Google BigQuery dataset.

📘

This article is for a Google Cloud admin or DevOps

The steps grant a service account read access to your export bucket and ownership of one BigQuery dataset. Make sure you understand each step before you run it.

Complete the Google Cloud Storage export first; the ETL service for BigQuery loads from that bucket.

Create a service account with access to the bucket and the dataset

1. Create a new service account in your project with the "Storage Insights Collector Service" and "BigQuery Job User" roles, roles/storage.insightsCollectorService and roles/bigquery.jobUser.
2. Create a key for it and download the JSON file.
3. In the export bucket's Permissions, grant the service account the "Storage Object User" role, roles/storage.objectUser.
4. Create a BigQuery dataset for the data, for example attribution_dataset.
5. Share the dataset with the service account, with the "BigQuery Data Owner" role, roles/bigquery.dataOwner.

Set up the ETL in Attribution

Open Settings → Data Export, choose Google BigQuery and enter:

1. Your Google project ID, for example attribution-1234.
2. The dataset name, for example attribution_dataset.
3. The contents of the service account's key file (JSON).
4. The name of the Cloud Storage bucket your export lands in.

Save, and the first load runs after the next daily export.