You can use a Google BigQuery object as a target in a data loader task.
When create a data loader task to write data to Google BigQuery, specify the Google BigQuery V2 target properties.
The following table describes the Google BigQuery V2 target properties:
Property
Description
Connection
Name of the target connection. Select a target connection or create a new connection.
Target Name Prefix
Optional prefix for the target table names.
If you enter a prefix, the target table names will be written as <prefix><source object>.
For example, if you enter "pfx1_" as the prefix, then data from source object "src1" will be written to target table "pfx1_src1."
Path
The Google BigQuery dataset name.
Update mode for Google BigQuery targets
The data loader task performs an insert or upsert operation based on how you define the primary key and watermark fields in the source object.
If you define the primary key field, the data loader task performs an upsert operation.
If you do not define a primary key or watermark fields, the data loader task performs an insert operation.
Note: When you write data of the String data type into a Google BigQuery target, the data loader task writes the data up to precision of 256 digits. The Hosted Agent truncates the data if the precision is greater than 256.