Cloud Data Integration Connectors All Products
When a Google BigQuery source contains columns with the REQUIRED constraint and you use
Create New at Runtimeto write data, the columns are created with the NULLABLE constraint in the target table.
When you select a Google BigQuery partitioned table as a source or target in a mapping, you cannot preview data.
When you use Create New at Runtime to write data to Google BigQuery, the mapping task creates the physical target based on the fields from the upstream transformation in the initial run.
In subsequent runs, the mapping task runs successfully even though it should fail.
If you configure a Lookup transformation to look up data from a Google BigQuery source and the source contains column of Numeric data type, the mapping fails.
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.