Connecting ODBC Driver to Google BigQuery

Windows DSN Configuration

After installing the driver, create a DSN for Google BigQuery in the ODBC Data Source Administrator.

1. Open the ODBC Data Source Administrator in one of the following ways:
   • In the Windows search box, enter ODBC Data Sources, then choose the application that matches the bitness of the third-party application (32-bit or 64-bit).
   • In Control Panel, select System and Security > Windows Tools, then double-click ODBC Data Sources (32-bit) or ODBC Data Sources (64-bit). Note that before Windows 8, the icon was named Data Sources (ODBC).
   • Run C:\Windows\SysWOW64\odbcad32.exe to create a 32-bit DSN or C:\Windows\System32\odbcad32.exe to create a 64-bit DSN.
2. Select the User DSN or System DSN tab. Most applications work with both types, yet some applications require a specific type of DSN.
3. Click Add. The Create New Data Source dialog opens.
4. Select Devart ODBC Driver for Google BigQuery, then click Finish. The driver configuration dialog opens.
5. Enter your Project Id and Dataset Id.
6. In Authentication, select the authentication method used to connect to Google BigQuery.
   • User Account: Select this option to authenticate with your personal Google account. Click Sign in to Google BigQuery.
     Refresh Token is automatically filled in. Select Save Token to remember the refresh token.

   

   • Service Account: Select this option to authenticate using a Google Cloud service account. This method is typically used for automated processes or server-side connections and requires a service account key file. Click Private Key JSON.

   

   In the Private Key JSON dialog that opens, click Load, select the file with the JSON key, then click Save.

   

7. Optional: Click Test Connection to verify the connection settings.
8. Click OK.

See Also

Connection String Parameters