Connections > Google BigQuery V2 connection > Connect to Google BigQuery
  

Connect to Google BigQuery

Let's configure the Google BigQuery V2 connection properties to connect to Google BigQuery.

Before you begin

Before you configure a Service Account connection, download the Google service account key file in JSON format. The service account key file is created when you create a Google service account. The key file contains the client email, private key, and project ID that you use to create a Service Account connection.
The following video shows you how to get the information you need from your Google BigQuery account:
https://infa.media/3e4LzdW
For information about the Workload Identity Federation prerequisites, see the following topics:

Connection details

The following table describes the basic connection properties:
Property
Description
Connection Name
Name of the connection.
Each connection name must be unique within the organization. Connection names can contain alphanumeric characters, spaces, and the following special characters: _ . + -,
Maximum length is 255 characters.
Use Secret Vault
Stores sensitive credentials for this connection in the secrets manager that is configured for your organization.
This property appears only if secrets manager is set up for your organization.
When you enable the secret vault in the connection, you can select the credentials that the Secure Agent retrieves from the secrets manager. If you don't enable this option, the credentials are stored in the repository or on a local Secure Agent, depending on how your organization is configured.
Note:
If you’re using this connection to apply data access policies through pushdown or proxy services, you cannot use the Secret Vault configuration option.
For information about how to configure and use a secrets manager, see Secrets manager configuration.
Runtime Environment
Informatica Cloud Hosted Agent, the runtime environment where you want to run tasks.

Authentication types

Google BigQuery V2 Connector connects to Google BigQuery with a service account key or with Workload Identity Federation (WIF).
Select one of the following authentication types in the connection:
Authentication type
Description
Service Account
Authenticate with the credentials in a Google service account key file.
WIF (Authorization Code)
Authenticate with WIF and an identity provider that uses the OAuth 2.0 authorization code grant. You sign in to the identity provider to generate an access token.
You can configure Okta as the identity provider.
WIF (Client Credentials)
Authenticate with WIF and an identity provider that uses the OAuth 2.0 client credentials grant. The connection doesn't require a user to sign in. You can also impersonate a service account and access datasets in a different project.
You can configure Microsoft Entra ID as the identity provider.
Select the required authentication type and configure the authentication-specific parameters.
Default is Service Account authentication type.

Connection retry

The following table describes the properties for connection retry:
Property
Description
Enable Retry
Does not apply to a data loader task.