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-97331
When you run a mapping with Streaming as the write mode, the mapping fails with the following error for the Byte, Date/Time, and Numeric data types:
  • - Byte: [ERROR] The following error occurred while loading data: [Failed to decode bytes input. Byte fields must be base64 encoded, value: java.nio.HeapByteBuffer[pos=0 lim=14 cap=14].]
  • - Date/Time: [ERROR] The following error occurred while loading data: [Epoch second value -2189418433211000 out of range]
  • - Numeric: [ERROR] Error Occured for Transformation - Source while writing the data to DTM Buffer - Data Conversion Failed
(July 2024)
CCON-96963
When the BigQuery Storage API is enabled in the connection and the source object in a mapping is a view with key-range partitioning defined, the mapping runs successfully initially. However, when you rerun the mapping, the staging tables created during the first run are not deleted and the mapping fails with the following error:
[ERROR] The following error occurred: [Already Exists: Table automation-bigquery-project:QATEST.query_tab_view_p_2]
(July 2024)
CCON-94513
When you configure the BigQuery Storage API to stage files in the connection and run a mapping, the mapping fails in the following scenarios:
  • - When the mapping reads data from multiple source objects.
  • - When an connected uncached Lookup transformation is configured for view objects.
  • - When the mapping is enabled with source SQL ELT optimization.
(April 2024)
CCON-79744
When you configure an uncached Lookup transformation in a mapping to look up data from a Google BigQuery source, and the source column contains a NULL value in the first row, data corruption occurs in the target.
If the source contains a NULL value in any other rows of the column, the mapping considers the filter condition for the previous row. This results in data duplication in the target.
(April 2024)

Known issues

The following table describes known issues:
Issue
Description
CCI-4472
When you edit the metadata of an existing mapping and a column name contains special character, the mapping fails with the following error:
[ERROR] The [QUERY] job failed with the following error: [Unrecognized name: <column name>]
(July 2024)
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.
(November 2024)
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)
CCORE-6234
When the lookup source contains a decimal data type and the precision of the value is greater than 28 in a Lookup transformation, the mapping fails with the following error:
Error: Internal error. The DTM process terminated unexpectedly. Contact Informatica Global Customer Support.
(July 2024)