BigQuery

Connecting to BigQuery

  1. To add a new connection, navigate to the File top menu and click on Edit Connections (or press [ + O] | [Ctrl + O]), or click the Add icon (➕) next to the Connections header in the Database Explorer panel, and select BigQuery:

    Screenshot_2022-04-04_at_11.42.20.png

  2. To finish creating a connection, enter valid data in the fields of the New connection dialog:

    Screenshot_2022-04-04_at_11.43.44.png

    • Connection name – Replace the default New Connection with a meaningful value.
    • Database JDBC driver – Specify user drivers for the data source, or click the 'download them' link below this field settings area. For detailed instructions on setting up drivers, see Add a user driver to an existing connection.
    • Host – The default value is https://www.googleapis.com/bigquery/v2.
    • Authentication – The default value is Service Account.
      The Simba JDBC Driver for Google BigQuery uses the OAuth 2.0 protocol for authentication and authorization. It authenticates your connection through Google OAuth APIs.
      For more information about OAuth authentication using a service account, see "Using OAuth 2.0 for Server to Server Applications" in the Google Identity Platform documentation: https://developers.google.com/identity/protocols/OAuth2ServiceAccount.
      Going forward, the following types will be available: Google User Account, Pre-Generated Access and Refresh Tokens, Application Default Credentials, etc..
    • Project ID– Set the name of your BigQuery project.
    • Connection timeout (sec) – The default value is 10. Specify another timeout, if needed, to tell the session when to disconnect.
    • Advanced Properties – Supply additional JDBC parameters if needed.
  3. Click Test to ensure that the connection to the data source is successful.
  4. Click Save. A newly created connection will be displayed in your Database Explore panel just right under the Connections header.

🔎 NOTE:  If you need more advanced information on how to set up a BigQuery connection, please, contact us through support@coginiti.co

Connect to BigQuery platform using a Google Service Account

Before you begin:

  1. Select ‘BigQuery’ item from the dropdown:
    Screenshot_2022-04-04_at_11.42.20.png
  2. Populate the connection properties on the ‘Connections’ screen:
    2.1. Fill in the ‘Connection name’ field
    2.2. Create JDBC driver and download driver files:
              on the ‘Connections’ screen: click the ‘download them’ link
         OR
              on the ‘JDBC Drivers’ screen:
                   - select ‘BigQuery’ item from the dropdown:
    Screenshot_2022-04-04_at_11.45.01.png
                   - click the ‘Download’ and then ‘Create driver’ button:
    Screenshot_2022-04-04_at_11.45.34.png

    🔎 NOTE: If you are experiencing issues or have special needs, get the necessary JDBC drivers from your DB vendor or from the public Maven repository (see https://cloud.google.com/bigquery/docs/reference/odbc-jdbc-drivers) and download them manually (see https://support.aginity.com/hc/en-us/articles/4411750800023-Drivers).
                   - select created driver from the ‘Database JDBC driver’ dropdown on the ‘Connections’ screen:
    Screenshot_2022-04-04_at_11.46.25.png
    2.3. Select ‘Service Account’ from the ‘Authentication’ dropdown
    2.4. Set the ‘Private Key’ property:
              copy a body of the private key file (in .json format) that is used to authenticate the service account email address, and paste it to the field
         OR
              select the private key file from the directory:
    Screenshot_2022-04-04_at_11.47.09.png
    2.5. Set the ‘Service Account Email’ property to your Google service account email address
    2.6. Set the ‘Project ID’ property to the name of your BigQuery project
    🔎 NOTE: You must manually fill in the ‘Project ID’ field when creating the connection.
    2.7. Save created connection.

  3. Create database objects and review them in the ‘Database Explorer’ and ‘Discovery’ panels:
    Screenshot_2022-04-04_at_11.47.58.png

Connect to BigQuery platform using a Google User Account

Before you begin

  1. Navigate to the 'Connections' screen to add a connection to BigQuery platform:
    Screenshot_2022-02-04_at_11.22.04.png
  2. Select ‘User Account’ from the ‘Authentication’ dropdown
  3. Populate 'Client ID' and 'Client Secret' fields with ID and secret values of your client credentials (created above)
  4. Fill in the ‘Project ID’ field with the name of your BigQuery project
    🔎 NOTE: You must manually fill in the ‘Project ID’ field when creating the connection.
    Screenshot_2022-02-04_at_11.39.19.png
  5. Click the 'Test' button to initiate an OAuth consent flow
  6. Once the flow is complete, return to the 'Connections' screen to verify that the connection was successful and save it:
    Screenshot_2022-02-04_at_12.21.27.png
Was this article helpful?
0 out of 0 found this helpful
Have more questions? Submit a request