Skip to main content

Striim for BigQuery Documentation

Configure a BigQuery service account

To connect to BigQuery, Striim requires a service account (see Service Accounts) associated with the project in which the target tables will be created.

The service account must have the BigQuery Data Editor, BigQuery Job User, and BigQuery Resource Admin roles for the target tables (see BigQuery predefined Cloud IAM roles). Alternatively, you may create a custom role with the following permissions for the target tables (see BigQuery custom roles):

  • bigquery.datasets.create

  • bigquery.datasets.get

  • bigquery.jobs.create

  • bigquery.jobs.get

  • bigquery.jobs.list

  • bigquery.jobs.listAll

  • bigquery.tables.create

  • bigquery.tables.delete

  • bigquery.tables.get

  • bigquery.tables.getData

  • bigquery.tables.list

  • bigquery.tables.update

  • bigquery.tables.updateData

  • bigquery.tables.updateTag

After you have created the service account, download its key file (see Authenticating with a service account key file). You will upload this file when you create your first pipeline.

In this section: