Using Application Default Credentials

You can configure the connector to authenticate the connection using credentials obtained through Application Default Credentials on the environment, if they are available. For information about how to configure Application Default Credentials, see "Google Application Default Credentials" in the Google Identity Platform documentation: https://developers.google.com/identity/protocols/application-default-credentials.

For more information about authenticating through OAuth 2.0, see "Using OAuth 2.0 to Access Google APIs" in the Google Identity Platform documentation: https://developers.google.com/identity/protocols/OAuth2.

To configure authentication using Application Default Credentials:

  1. Set the OAuthType property to 3.
  2. Set the ProjectID property to the name of your BigQuery project.

For example:

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