Consider the following rules and guidelines when you configure an SQL transformation in mappings:
You can only configure a connected SQL transformation with Google BigQuery V2 Connector.
When you configure an SQL transformation and configure an output field, record data type is not applicable for Google BigQuery V2 Connector.
When you configure a SQL transformation to call stored procedures or entered query, columns of Record data type and repeated columns are not applicable.
You cannot call a stored procedure from an entered query.
When you configure an SQL transformation to process an entered query, the following properties are not applicable:
Inout and input parameters
Auto commit
Transformation scope
Stop on error
Continue on SQL Error within Row
When you provide the billing project ID in the SQL transformation advanced properties, you must specify the project ID in the SQL query.