Data Integration Connector Release Notes > Connector and connectivity issues > Google BigQuery V2 Connector
  

Google BigQuery V2 Connector

Fixed issues

The following table describes fixed issues:
Issue
Description
CCON-103155
When you run a mapping enabled with SQL ELT optimization and use the +, -, *, and % operators within an Expression transformation inside parentheses, the query result might be incorrect because the parentheses for these operators are not honored and are removed from the query.
(April 2025)
CCON-102353
When you enable the optional property SupportParameterisedDatatype for the Google BigQuery V2 connection and configure a SQL ELT mode mapping to read from an Amazon S3 or Google Cloud Storage source and create the target at runtime, the mapping ignores the optional property and runs successfully.
(April 2025)

Known issues

The following table describes known issues:
Issue
Description
CBDM-38003
When you run a mapping configured with SQL ELT mode that contains a Joiner, Lookup, or Normalizer transformation connected to another Normalizer transformation, the mapping fails with the following error:
An error occurred during mapping translation: Internal error.
(April 2025)
CBDM-38002
When you run a mapping configured with SQL ELT mode that contains a Normalizer transformation connected to an Expression transformation, and the generated column ID field is used as the first operand in an expression within the transformation, the mapping fails.
Workaround: Update the expression by changing the first operand and run the mapping again.
For example, if the mapping with Generated column ID field + 100 scenario in an expression fails, update the expression to 100 + Generated column ID field.
(April 2025)
CCON-101829
When you run a mapping task that is based on a mapping in SQL ELT mode, and the mapping contains a parameterized unconnected Lookup transformation, the task fails with the following error:
An error occurred during mapping translation: Unable to fetch fields for Lookup: U_Lookup
(October 2024)