When you configure a Target transformation in a mapping in SQL ELT mode, you need to use only a
Google BigQuery V2
connection.
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