Cloud Data Integration Connectors All Products
When you run a mapping that reads data from a Google BigQuery source that contains columns with the REQUIRED constraint and you select Create Target to write data to a Google BigQuery target, the columns are created with the NULLABLE constraint in the target table.
If a Google BigQuery source contains the DATE, DATETIME, TIME, or TIMESTAMP data types and you create a Google BigQuery target at run time, the Secure Agent writes TIMESTAMP data to the target.
When the source object contains more than 5000 columns, you cannot create a Google BigQuery target at runtime and the Secure Agent displays an error icon instead of an error message.
If you configure proxy settings for Google BigQuery V2 Connector, the Secure Agent does not log the proxy details in the session log.
When you write data to a Google BigQuery target, the Secure Agent does not write any row to the success file or error file.
When you specify incorrect credentials in the connection properties, the test connection is successful.