logo

Grant BigQuery access to SegmentStream

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:
  1. Open your SegmentStream project.
  1. Navigate to SettingsBigQuery, and copy the service account email.
    1. Image without caption
  1. Go to the Google Cloud Platform Console.
  1. Open the console left side menu and click IAM & admin. Select IAM from the list.
    1. Image without caption
  1. Click GRANT ACCESS:
    1. Image without caption
  1. Paste the service account email address into New principals field.
  1. Select the BigQuery Data Editor and BigQuery User roles.
  1. Click Save.
    1. Image without caption
  1. Return to your SegmentStream project and navigate to Settings → BigQuery.
  1. Check access by clicking the TEST AND CONNECT BIGQUERY button.
    1. Image without caption
  1. You can now follow the BigQuery guide to complete the connection - Google BigQuery

Dataset access

  1. Open your SegmentStream project.
  1. Navigate to SettingsBigQuery, and copy the service account email.
    1. Image without caption
  1. Go to the Google Cloud Platform Console.
  1. Navigate to BigQuery Studio.
  1. Create a new dataset inside your project and name it segmentstream.
    1. ⚠️
      Make sure that the data location of the BigQuery dataset created aligns with the BigQuery link configuration in your GA property.
      Image without caption
  1. Select the newly created dataset in the resource selector on the left, and click SHARINGPermissions.
    1. Image without caption
  1. 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.
    1. Image without caption
  1. Return to your SegmentStream project and navigate to Settings → BigQuery.
  1. Check access by clicking the TEST AND CONNECT BIGQUERY button.
    1. Image without caption