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 which 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. |
Property | Description |
|---|---|
Service Account Email | The client_email value from the Google service account key JSON file. |
Service Account Key | The private_key value from the Google service account key JSON file. To use the private key from the JSON file, enter the entire block of text found within the double quotation marks in the private_key field, starting with -----BEGIN PRIVATE KEY-----\n and ending at -----END PRIVATE KEY-----\n. |
Project ID | The project_id value from the Google service account key JSON file. If you have created multiple projects with the same service account, enter the ID of the project that contains the dataset that you want to connect to. |
Property | Description |
|---|---|
Enable BigQuery Storage API | Does not apply to a data loader task. |
Storage Path | Path in Google Cloud Storage where the agent creates a local stage file to store the data temporarily. The agent uses this storage when it reads data in staging mode or writes data in bulk mode. Use one of the following formats:
When you enable cross-region replication in Google BigQuery, enter a Google Cloud Storage path that supports dual region storage. |
Connection Mode | The mode that you want to use to read data from or write data to Google BigQuery. Select one of the following connection modes:
Default is Simple. |
Use Legacy SQL for Custom Query | Select this option to use legacy SQL to define a custom query. If you clear this option, use standard SQL to define a custom query. This property doesn't apply if you configure the Google BigQuery V2 connection in hybrid or complex mode. |
Dataset Name for Custom Query | The name of the Google BigQuery dataset that you want to specify in a custom query. |
Schema Definition File Path | Storage path in Google Cloud Storage where the Hosted Agent create a JSON file with the sample schema of the Google BigQuery table. You can download the JSON file from the specified storage path in Google Cloud Storage to a local machine. |
Region ID | The region name where the Google BigQuery dataset that you want to access resides. Note: Ensure that you specify a bucket name or the bucket name and folder name in the Storage Path property that resides in the specified region. For more information about the regions supported by Google BigQuery, see Dataset locations. |
Staging Dataset | The Google BigQuery dataset name where you want to create the staging table to stage the data. You can define a Google BigQuery dataset that is different from the source or target dataset. |
Provide Optional Properties | Comma-separated key-value pairs of custom properties in the Google BigQuery V2 connection to configure certain source and target functionalities. |
Property | Description |
|---|---|
Project Number | The unique numeric identifier of the project in the Google service account that contains the dataset that you want to connect to. |
Authorization URL | The endpoint URL provided by the identity provider where user authentication requests are redirected to initiate the authorization process. |
Access Token URL | The endpoint URL provided by the identity provider where the client exchanges authorization codes or credentials to obtain access tokens. |
Client Id | A unique identifier assigned to your application by the identity provider. This ID is used to recognize the requester during authentication and authorization processes. |
Client Secret | A confidential key issued alongside the client ID, acting as a password between your application and the identity provider to prove the authenticity of the client during token exchanges. |
Pool Id | The identifier for the Workload Identity Pool configured in Google Cloud Platform which aggregates trusted external identities. |
Provider Id | The ID of the specific external identity provider configured within the Workload Identity Pool. |
Access Token | The access token granted by Google Cloud Platform to securely access Google BigQuery resources. Click Generate Access Token to generate a new access token. |
Property | Description |
|---|---|
Enable BigQuery Storage API | Does not apply to a data loader task. |
Storage Path | Path in Google Cloud Storage where the agent creates a local stage file to store the data temporarily. The agent uses this storage when it reads data in staging mode or writes data in bulk mode. Use one of the following formats:
When you enable cross-region replication in Google BigQuery, enter a Google Cloud Storage path that supports dual region storage. |
Dataset Name for Custom Query | The name of the Google BigQuery dataset that you want to specify in a custom query. |
Region ID | The region name where the Google BigQuery dataset that you want to access resides. Note: Ensure that you specify a bucket name or the bucket name and folder name in the Storage Path property that resides in the specified region. For more information about the regions supported by Google BigQuery, see Dataset locations. |
Provide Optional Properties | Comma-separated key-value pairs of custom properties in the Google BigQuery V2 connection to configure certain source and target functionalities. |