Strategy ONE

Create a Google BigQuery JDBC DSN-less Connection Using a Service Account in Developer

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, Strategy 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. Log into MicroStrategy Developer.

  2. Expand Administration > Configuration Managers.

  3. Right-click Database Instances > New > Database Instance.

  4. Enter a database instance name.

  5. From the Database connection type drop-down, choose Google BigQuery.

  6. Click New.

  7. Enter a database connection name and select a default database login name.

  8. Go to the Advanced tab.

  9. Obtain the following:

    • Project ID, which is also your billing project (ProjectId)

    • Service account email (OAuthServiceAcctEmail)

    • Path to the JSON (recommended) or P12 password file (OAuthPvtKeyPath)

    If you do not have your credentials, see the Google Cloud documentation.

  10. Modify the following connection string template with the information in step 9:

    Copy 
    JDBC;DRIVER={com.microstrategy.googlebigquery.jdbc42.Driver};URL={jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=PROJECT_ID;OAuthType=0;OAuthServiceAcctEmail=SERVICE_ACCOUNT_EMAIL;OAuthPvtKeyPath=PATH_TO_YOUR_KEY_FILE;Timeout=600;EnableHighThroughputAPI=1}

  11. Copy the modified connection string and paste it in the Additional connection string parameters field.

  12. Click OK.