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. |
Description | Description of the connection. Maximum length is 4000 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 | The name of the runtime environment where you want to run tasks. |
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. |
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 |
|---|---|
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 to a dual-region bucket. |
Connection Mode | The mode that you want to use to read data from or write data to Google BigQuery. 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. |
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 | |
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 the list of Google BigQuery regions, 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. |