Database Compare Suite™

Connecting to a BigQuery data warehouse

Use the following procedure to connect to BigQuery.

  1. Click the New icon in the Project panel at the top left corner of the window.

  2. Select BigQuery in the Platform drop-down list at the top of the dialog box.

    connect to bigquery

  3. Select the Standard option in the Mode drop-down list if you would like to connect to BigQuery in the standard mode.

    connect to bigquery standard mode

    • Specify the Credentials file path and the Project ID in appropriate fields. You can enter these parameters manually or select them from drop-down lists.

    • Press the Test button to verify that you can successfully connect to BigQuery.

  4. Select the Connection String option in the Mode drop-down list if you would like to connect to BigQuery using special connection string.

    connect to bigquery connection string

    • Enter the Connection string manually or select from the drop-down list (if it has been used already).

    • Find the connection string template below. Use it as an example to create a connection string that allows to connect to BigQuery:

      ProjectID=my_project;CredentialsPath=C:\GoogleCredentials\my_credentials.json;
      
    • Press the Test button to verify that you can successfully connect to BigQuery.


Didn’t find the answer?

You can report problems, ask questions or share ideas for improvements on our email [email protected].