Using a Google User Account

You can configure the connector to authenticate the connection with a Google user account.

You must provide your Google user account credentials to connect to the server. For more information about authenticating through OAuth 2.0 with a Google user account, see "Using OAuth 2.0 to Access Google APIs" in the Google Identity Platform documentation: https://developers.google.com/identity/protocols/OAuth2.

To configure user account authentication:

  1. Connect to the server using a connection URL written in the following format:

    2. jdbc:bigquery://[Host]:[Port];ProjectId=[Project];
    OAuthType=1;

    The variables are defined as follows:

    • [Host] is the DNS or IP address of the server.
    • [Port] is the number of the TCP port to connect to. Specifying the port number is optional if you are connecting to port 443.
    • [Project] is the name of your BigQuery project.

    For example:

    jdbc:bigquery://https://www.googleapis.com/bigquery/v2:443;ProjectId=MyBigQueryProject;OAuthType=1;

  2. The connector opens a browser to the Google sign-in page, and triggers a listener in the background. If the sign-in in the browser is successful, the connector gets the refresh token and stores it.

Related topics