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

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