MicroStrategy ONE

Generate a Confirmation Number for Google BigQuery

Make sure that your user or service account has at least the following Google BigQuery roles assigned at the project level.

  • BigQuery Data Owner

  • BigQuery Job User

  • BigQuery User

It may be possible to assign these roles on the dataset or table level. However, MicroStrategy has not tested these other scenarios. To learn more about granting roles to an user, see Manage access to projects, folders, and organizations in the Google IAM documentation.

  1. Go to the Google BigQuery Client Tool.
  2. Log into your Google account.
  3. Click Allow to allow MicroStrategy to access your Google BigQuery data.
  4. Copy the confirmation code and close the dialog.