You can specify pre SQL and post SQL advanced properties for Google BigQuery sources and targets. When you create a task in Data Integration, you can specify SQL commands in the advanced properties for a source and target.
You can perform the following operations by using pre SQL and post SQL commands:
•SELECT
•UPDATE
•DELETE
Note: You cannot perform more than one operation with a pre SQL or post SQL command.
You can configure the options in Google BigQuery with a pre SQL or post SQL statement in the pre SQL Configuration or post SQL Configuration advanced properties for Google BigQuery sources and targets.
You must use the following format to specify a pre SQL configuration or a post SQL configuration:
<Option1:Value1,Option2:Value2,...OptionN:ValueN>
The following table shows the configuration options and supported values that you can specify in a pre SQL configuration or post SQL configuration:
Options
Supported Values
DestinationDataset
Dataset ID in Google BigQuery
DestinationTable
Table name in Google BigQuery
FlattenResults
True and False
UseLegacySQL
True and False
WriteDisposition
WRITE_TRUNCATE, WRITE_APPEND, and WRITE_EMPTY
Note: If you perform an UPDATE or DELETE operation with a pre SQL or post SQL command, you must specify the following parameter in the pre SQL configuration or post SQL configuration: