You can specify

pre SQL

and

post SQL

data object read and write operation properties for Google BigQuery data objects. When you create a data object read or write operation in the Developer tool, you can specify SQL commands on the

Advanced

view.

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

data object read and write operation properties for Google BigQuery data objects.

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