Strategy ONE

Google BigQuery ODBC Service Account Authentication for Linux and Windows

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.

Generate the Access File

  1. Go to the Google Cloud Platform.

  2. Select a project and service account.
  3. Select a JSON file.
  4. Click Create and download the file.
  • Web
  • Workstation
  1. Open the ODBC Data Sources (64-bit) application.
  2. Go to the System DSN tab.
  3. Click Add.
  4. Select Strategy Google BigQuery ODBC Driver.

  5. Complete the required fields. You must use the appropriate email as well as key file path, which must be a JSON file.

    1. Open the odbc.ini file located under /opt/mstr/MicroStrategy.

    2. Add the following information like the following example. You must use the correct values for Catalog, Email, KeyFilePath, and DefaultDataset.

      Copy 
      [ODBC Data Sources]

      GBQ=MicroStrategy Google BigQuery ODBC Driver



      [GBQ]
      Driver=/opt/mstr/MicroStrategy/install/lib/libgooglebigqueryodbc_sb64.so
      Description=MicroStrategy Google BigQuery ODBC Driver
      Catalog=microstrategyub
      DefaultStringColumnLength=4000
      Email=mstrlabs@steam-strategy-123456.iam.gserviceaccount.com
      KeyFilePath=/opt/mstr/MicroStrategy/MicroStrategyTestProject-a16bde446e8b.p12
      OAuthMechanism=0
      ProxyHost=
      ProxyPort=0
      ProxyPwd=
      ProxyUid=
      RefreshToken=
      RowsFetchedPerBlock=100000
      SQLDialect=1
      DefaultDataset=GBQTest
    3. Save the file.

    4. Restart the Intelligence server by executing the following command:

      Copy 
      /opt/mstr/MicroStrategy/bin/mstrctl -s IntelligenceServer terminate

      and

      Copy 
      /opt/mstr/MicroStrategy/bin/mstrctl -s IntelligenceServer start