Strategy ONE

Generate a Refresh Token to Access Google BigQuery on Windows

  1. Log into your Windows machine.
  2. In the left bottom corner, click Start.
  3. Search for ODBC Data Sources (64-bit) and open it. The ODBC Data Source Administrator (64-bit) window appears.
  4. Go to the System DSN tab.
  5. Click Add.
  6. Select a platform for which you want to create the ODBC connection.

    • If creating an ODBC connection for Web on Windows, select Strategy Google BigQuery ODBC Driver and click Finish.

    • If creating an ODBC connection for Workstation, select Strategy Google BigQuery ODBC Driver Client and click Finish.

      If you do not select the Strategy Google BigQuery ODBC Driver Client option, the connection will not be visible nor usable in Strategy Workstation.

  7. In the Strategy ODBC Driver for Google BigQuery DSN Setup dialog, enter a data source name.
  8. From the OAuth Mechanism drop-down, choose User Authentication.
  9. Click Sign In.
  10. Log into your Google account.
  11. Click Allow to allow Strategy to access your Google BigQuery data.
  12. Copy the confirmation code that is displayed and close the dialog. You are returned back to the Strategy ODBC Driver for Google BigQuery DSN Setup dialog.
  13. In the Confirmation Code field, paste the confirmation code.

  14. Click the Refresh Token field. The refresh token is automatically populated with your refresh token.