Data Ingestion and Replication
- Data Ingestion and Replication
- All Products
ASK INFAPreview
Please log in to access Bolo.
ASK INFAPreview
Property
| Description
|
|---|---|
Connection Name
| The name of the connection. The name is not case sensitive and must be unique within the domain. You can change this property after you create the connection. The name cannot exceed 128 characters, contain spaces, or contain the following special characters:~ ` ! $ % ^ & * ( ) - + = { [ } ] | \ : ; " ' < , > . ? /
|
Description
| Optional. The description of the connection. The description cannot exceed 4,000 characters.
|
Type
| The
Google Big Query V2 connection type.
|
Runtime Environment
| Name of the runtime environment where you want to run the tasks.
You cannot run a database ingestion task on a Hosted Agent or serverless runtime environment.
|
Service Account ID
| Specifies the client_email value present in the JSON file that you download after you create a service account.
|
Service Account Key
| Specifies the private_key value present in the JSON file that you download after you create a service account.
|
Project ID
| Specifies the project_id value present in the JSON file that you download after you create a service account.
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.
|
Storage Path
| This property applies when you read or write large volumes of data. Required if you read data in staging mode or write data in bulk mode.
Path in Google Cloud Storage where the agent creates a local stage file to store the data temporarily.
You can either enter the bucket name or the bucket name and folder name.
For example, enter
gs://<bucket_name> or
gs://<bucket_name>/<folder_name>
|
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.
|
Schema Definition File Path¹
| Specifies a directory on the Secure Agent machine where the Secure Agent must create a JSON file with the sample schema of the Google BigQuery table. The JSON file name is the same as the Google BigQuery table name.
Alternatively, you can specify a storage path in Google Cloud Storage where the Secure Agent must 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.
The schema definition file is required if you configure complex connection mode in the following scenarios:
When you use a serverless runtime environment, you must specify a storage path in Google Cloud Storage.
|
Use Legacy SQL For Custom Query¹
| Select this option to use a legacy SQL to define a custom query. If you clear this option, you must use a standard SQL to define a custom query.
Not applicable when you configure the Google BigQuery V2 connection in hybrid or complex mode
|
Dataset Name for Custom Query¹
| When you define a custom query, you must specify a Google BigQuery dataset.
|
Region Id
| Specify the region name where the Google BigQuery dataset that you want to access resides.
You must 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 the following Google BigQuery documentation:
https://cloud.google.com/bigquery/docs/locations
|
Optional Properties¹
| Specifies whether you can configure certain source and target functionalities through custom properties.
You can select one of the following options:
Default is None.
|
Provide Optional Properties¹
| Comma-separated key-value pairs of custom properties in the Google BigQuery V2 connection to configure certain source and target functionalities.
Appears only when you select
Required in the Optional Properties.
For more information about the list of custom properties that you can specify, see the Informatica Knowledge Base article:
https://kb.informatica.com/faq/7/Pages/26/632722.aspx
|
