Strategy ONE

Generate a Refresh Token to Access Google BigQuery on MacOS

  1. Generate a confirmation code for Google BigQuery.

  2. Go to the Google BigQuery page for ODBC and JDBC drivers.

  3. Download the Linux 32-bit and 64-bit (tar.gz) driver.

  4. On Mac, open the Terminal application.

  5. Navigate to the folder containing the downloaded file. For example, use the command, "cd ~/Downloads”.

  6. Decompress the downloaded file by executing the following command:

    The folder name may vary depending on the downloaded driver version. In this example, the 2.2.4.1011 release is used.

    Copy 
    tar xvf SimbaODBCDriverforGoogleBigQuery_2.2.4.1011-Linux.tar.gz

  7. Navigate to the decompressed folder by executing the following command:

    Copy 
    cd SimbaODBCDriverforGoogleBigQuery_2.2.4.1011-Linux

  8. Decompress the driver file by executing the following command:

    Copy 
    tar xvf SimbaODBCDriverforGoogleBigQuery64_2.2.4.1011.tar.gz

  9. Navigate to the Tools folder within the newly decompressed folder by executing the following command:

    Copy 
    cd SimbaODBCDriverforGoogleBigQuery64_2.2.4.1011/Tools

  10. Generate the OAuth refresh token by executing the following command, where <CONFIRMATION_CODE> is the confirmation code generated in step 1:

    Copy 
    ./get_refresh_token.sh <CONFIRMATION_NUMBER>

    The token is returned with a comma at the end. Do not copy the comma.