Skip to content

Connect to BigQuery ​

To get set up with BigQuery, you'll just need to provide us with a service account JSON file that provides read-only access with the BigQuery Job User and BigQuery Metadata Viewer roles to your project, and BigQuery Data Viewer to just the relevant datasets.

TIP

We recommend creating a new and separate service account for Supersimple, instead of reusing an existing service account you may have.

  1. Create a new service account in your Google Cloud console, under IAM & Admin. Name it anything, but you could just go with Supersimple.

    Google Cloud - Create service account
  2. Grant the service account access to your project from within IAM, with both the BigQuery Job User and BigQuery Metadata Viewer roles. Use the service account you just created as the principal.

    Google Cloud - Grant access to service account
    Google Cloud - Add principals to service account
  3. Open the BigQuery datasets you'd like to use on Supersimple and grant the service account the BigQuery Data Viewer role. Select the relevant dataset, then Share, then Manage Permissions, then Add Principal.

    Grant access to specific datasets

    Click Add Principal in the sharing options that open:

    Share access to principals

    Use the exact service account email you created previously, and choose BigQuery Data Viewer as the role.

    Add the Data Viewer role to your service account

    TIP

    In case you have multiple datasets you would like to connect, make sure to repeat these steps as appropriate for each BigQuery dataset.

  4. Once you've created the service account and granted it these permissions, you can download its credentials as a JSON file from IAM & Admin > Service Accounts > Keys and copy its contents into our onboarding flow.

    Create a Service Account key
  5. You'll also need to enter the dataset location (region or zone) in Supersimple. You can find this in BigQuery by selecting your dataset and looking at Dataset info.

    Find the dataset location in BigQuery