Google Cloud Storage V2 Connector > Mappings for Google Cloud Storage > Google Cloud Storage V2 targets in mappings
  

Google Cloud Storage V2 targets in mappings

To write data to a Google Cloud Storage V2 target, configure a Google Cloud Storage object as the Target transformation in a mapping.
Specify the name and description of the Google Cloud Storage V2 target. You can configure the target and advanced properties for the target object.
The following table describes the properties that you can configure for a Google Cloud Storage V2 target:
Property
Description
Connection
Name of the Google Cloud Storage V2 target connection. Select a source connection, or click New Parameter to define a new parameter for the source connection.
If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties.
Target Type
Type of the Google Cloud Storage target objects available. You can write data to a single target object or parameterize Google Cloud Storage target object. You cannot write data to multiple objects.
Object
Name of the Google Cloud Storage file.
Note: Ensure that the column names in the target object do not begin with special characters to successfully write data to the target.
Parameter
Select an existing parameter for the target object or click New Parameter to define a new parameter for the target object. The Parameter property appears only if you select Parameter as the target type.
If you want to overwrite the parameter at runtime, select the Allow parameter to be overridden at run time option when you create a parameter. When the task runs, the agent uses the parameters from the file that you specify in the task advanced session properties.
Create New at Runtime
Creates a target.
Enter a name and path for the target object and select the source fields that you want to use. By default, all source fields are used.
The target name can contain alphanumeric characters. You can use the following special characters in the file name: ., _, @, $, %
If you specify the path, the Secure Agent creates the target object in the path you specify in this property. The Secure Agent creates the target object in the following path:
<bucket_name>/<path_name>/<target_object_name>
You cannot parameterize the target at runtime.
When you create a mapping in advanced mode, you can use the CreateTarget option only for Avro, JSON, and Parquet format.
Format
Specifies the file format that the Google Cloud Storage V2 Connector uses to write data to Google Cloud Storage.
You can select the following file format types:
  • - Avro
  • - Delta
  • - Flat
  • - Iceberg
  • - JSON
  • - Orc¹
  • - Parquet
  • - None²
Note: If you select None is as the format type, Google Cloud Storage V2 Connector writes data to Google Cloud Storage files in binary format.
Open the Formatting Options dialog box to configure the formatting options for the file.
When you write binary data to a Google Cloud Storage V2 target created at run time, ensure that the incoming field that contains the binary data is named data. If the field name differs, use field rules or an Expression transformation to change the field name to data.
For more information about format options, see Google Cloud Storage file formatting options.
Operation
Select Insert as the target operation. You cannot perform update, upsert, or delete operations on a Google Cloud Storage object.
¹ Applies only to mappings in advanced mode.
² Doesn't apply to mappings in advanced mode.
The following table describes the advanced properties that you can configure for a Google Cloud Storage V2 target:
Property
Description
Google Cloud Storage Path
Overrides the Google Cloud Storage path where the target file exists.
Use the following format: gs://<bucket_name> or gs://<bucket_name>/<folder_name>
For example, gs://dlake_bkt/customer/sales
Note: If you use the Delta or Iceberg file format, specify the storage path in gs://<bucket_name>/<folder_name>/<file_name> format.
You can't specify wildcard characters in the Google Cloud Storage path.
Target File Name
Optional. Overrides the Google Cloud Storage target object name specified in the Target transformation.
Encryption Type
Method to encrypt data.
You can select one of the following encryption types:
  • - Informatica Encryption
  • - None
Default is None.
Compression Format1
Compresses data when you write to Google Cloud Storage.
You can compress the data in the following formats:
  • - None
  • - Gzip
  • - Deflate
  • - Snappy
Default is None.
In advanced mode, you can compress data only when you run a mapping that writes data to a Google Cloud Storage file in Parquet, JSON, or Delimited file formats.
Write Strategy
This property applies when you use the Delta or Iceberg file format in a mapping.
The strategy that you want to apply when writing data to the target file.
You can select one of the following options:
  • - Append
  • - Overwrite
Default is Overwrite.
Use Parallel Composite Upload
Optimizes the upload of large files to Google Cloud Storage using the Parallel Composite Upload strategy.
In this strategy, a file is divided into smaller chunks that are uploaded in parallel as temporary objects. The final object is then reassembled from these temporary objects, which are subsequently deleted.
Default is not selected.
Stop Partial Data Upload
Prevents the upload of partial data to the Google Cloud Storage target location if the mapping fails.
Default is not selected.
Forward Rejected Rows
This property is not applicable for Google Cloud Storage V2 Connector.
¹Applies only to mappings in advanced mode.