We will need access to your BigQuery, which will serve as the repository for your SegmentStream project, this can be done in two ways. One option is to access a BigQuery project that belongs to your company, which is more user-friendly. The other option is to access a specific dataset that you created for SegmentStream, offering a more advanced and secure approach.
Project access
Below are the steps that explain how to provide the necessary project access:
- Open your SegmentStream project.
- Navigate to Settings → BigQuery, and copy the service account email.
- Go to the Google Cloud Platform Console.
- Open the console left side menu and click IAM & admin. Select IAM from the list.
- Click GRANT ACCESS:
- Paste the service account email address into New principals field.
- Select the BigQuery Data Editor and BigQuery User roles.
- Click Save.
- Return to your SegmentStream project and navigate to Settings → BigQuery.
- Check access by clicking the TEST AND CONNECT BIGQUERY button.
- You can now follow the BigQuery guide to complete the connection - Google BigQuery
Dataset access
- Open your SegmentStream project.
- Navigate to Settings → BigQuery, and copy the service account email.
- Go to the Google Cloud Platform Console.
- Navigate to BigQuery Studio.
- Create a new dataset inside your project and name it segmentstream.
Make sure that the data location of the BigQuery dataset created aligns with the BigQuery link configuration in your GA property.
- Select the newly created dataset in the resource selector on the left, and click SHARING → Permissions.
- Enter the service account email from the SegmentStream interface into the New principals field, and select the BigQuery Data Editor and BigQuery User roles and click Save.
- Return to your SegmentStream project and navigate to Settings → BigQuery.
- Check access by clicking the TEST AND CONNECT BIGQUERY button.