Google BigQuery Connectors > Part III: Data Integration with Google BigQuery Connector > Synchronization Tasks with Google BigQuery Connector > Pre SQL and Post SQL Commands
  

Pre SQL and Post SQL Commands

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:
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:
UseLegacySQL:False