You can configure the following advanced properties in a

Google BigQuery

target transformation in a mapping in SQL ELT mode:

UpdateMode
Target Dataset ID
Target Table Name
pre SQL
post SQL
Truncate target table
Billing Project ID

For more information on how the targets in mappings in SQL ELT mode behaves differently from the targets in other types of mappings, see the Targets in mappings in SQL ELT mode topic in

Mappings

in the Data Integration help.