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 of the Source and Target transformations.

You can perform select, update, or delete operations with pre SQL and post SQL commands and 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.

Use the following format to specify a pre SQL configuration or a post SQL configuration:

<Option1:Value1,Option2:Value2,...OptionN:ValueN>

When you perform an update or delete operation with a pre SQL or post SQL command, specify the following parameter in the pre SQL configuration or post SQL configuration:

UseLegacySQL:False

The following table shows the configuration options and the values that you can specify in a pre SQL configuration or post SQL configuration:

Options	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