Create a Google BigQuery ODBC DSN for Linux

1. Obtain your valid refresh token. If you need to generate a refresh token, see Generate a Refresh Token to Access Google BigQuery on Linux

2. Connect to the Linux environment using SSH.

   Click here if you are using Mac.

   1. Open the Terminal application.

   2. Use the SSH command to connect to the hostname or IP address of your server.

   3. If prompted to confirm if you want continue, enter yes and press Enter.
   Click here if you are using Windows.

   1. Download and install the PuTTY application.

   2. Open PuTTY.

      

   3. Enter the hostname or IP address of your server and click Open.

   4. If the PuTTY Security Alert dialog appears, click Yes.

3. Enter your access password and press Enter. You are connected to the server via SSH.
4. Enter nano/opt/mstr/MicroStrategy/odbc.ini and press Enter. The odbc.ini file opens in the browser.

5. At the end of the [ODBC Data Sources] section, add the following:

   Copy

   GBQ ODBC=MicroStrategy Google BigQuery ODBC Driver

6. Add the following after the [ODBC Data Sources] section:

   Copy

   [GBQ ODBC]
   Driver=/opt/mstr/MicroStrategy/intall/lib/libgooglebigqueryodbc_sb64.so
   Description=MicroStrategy Google BigQuery ODBC Driver
   Catalog=MicroStrategyProject
   DefaultStringColumnLength=4000
   Email=
   KeyFilePath=
   OAuthMechanism=1
   ProxyHost=
   ProxyPort=0
   ProxyPwd=
   ProxyUid=
   RefreshToken=1//0eKWXcXE-731hCgYIASSAGA2SNwF-L9HrRmIj-czpr6UhY5K23Jtb2CRyEavDvzs2eTCpGE8NQaSdbwEJKKa9WzQze1UvG6W3HMp
   RowsFetchedPerBlock=100000
   SQLDialect=1
   DefaultDataset=GBQTest

   You must change the values of Catalog (Project) and RefreshToken to reflect your project and token information.

   The selected catalog or project is also your billing project.

7. Press Ctrl+X to exit the editor.
8. Press Y to confirm you want to save your changes.
9. Press Enter to confirm the file name. You are back in the terminal.
10. Enter exit and press Enter to exit the terminal.