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 connection, ensure that you download the Google service account key file in JSON format. The service account key file is created when you create a Google service account.
You require the client email, private key, and project ID from the service account key JSON file to create a Google BigQuery connection.
The following video shows you how to get the information you need from your Google BigQuery account:
https://infa.media/3e4LzdW

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.
Runtime Environment
Informatica Cloud Hosted Agent, the runtime environment where you want to run tasks.

Authentication types

You can configure Service Account or Workload Identity Federation authentication method to access Google BigQuery. When you use Workload Identity Federation authentication method, you can configure Okta as the identity provider.
Select the required authentication method and configure the authentication-specific parameters.
Default is Service Account authentication method.