Connector Release Notes

Connector Release Notes

Google BigQuery V2 Connector

Google BigQuery V2 Connector

Known issues

The following table describes known issues:
CR
Description
CCON-28308
When you use an ODBC connection to configure pushdown optimization and use a custom query to read data of the Decimal data type from a Google BigQuery source, the Secure Agent fails to fetch the value of the scale attribute. (February 2021)
CCON-27858
When you configure an advanced filter condition and run the Google BigQuery mapping, the mapping fails with the following error:
[ERROR] The [QUERY] job failed with the following error: [Field 'TableName.FldName' not found in table 'DatasetName.TableName'.]
Workaround: Remove the table name prefix from the field name in the filter condition and run the mapping. (February 2021)
CCON-26705
When you configure a Google BigQuery V2 connection in simple mode and enable
Use Legacy SQL For Custom Query
, the mapping fails if the field names of a record data type and a primitive data type are same.
Workaround: Unselect
Use Legacy SQL For Custom Query
and run the mapping.
(October 2020)
CCON-26575
When you configure a Google BigQuery V2 source connection in simple mode, enable the
Use Legacy SQL For Custom Query
option, and read data from a Google BigQuery view with standard SQL, the mapping fails. (October 2020)
CCON-26558
When you configure a Google BigQuery V2 source connection in simple mode, disable the
Use Legacy SQL For Custom Query
option, and read data from a Google BigQuery view with legacy SQL, the mapping fails. (October 2020)
CCON-25964
When you configure a Google BigQuery V2 source connection in simple mode, enable the
Use Legacy SQL For Custom Query
option, and read data from a Google BigQuery materialized view, the mapping fails. (October 2020)
CCON-20477
If you configure an uncached Lookup transformation to look up data from a Google BigQuery source and the source contains a column of DateTime or Timestamp data type, the mapping fails for certain values with the following error:
java.lang.RuntimeException: Invalid expression string for filter condition.
(April 2020)
CCON-20414
If you configure an uncached Lookup transformation to look up data from a Google BigQuery source and the source contains a NULL value, an error occurs in the following scenarios:
  • If the source contains a NULL value in the first row of the column, the mapping fails.
  • 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 lookup table.
(April 2020)
CCON-20235
When a Google BigQuery source contains columns with the REQUIRED constraint and you use
Create New at Runtime
to write data, the columns are created with the NULLABLE constraint in the target table. (November 2019)

Third-party known issues

The following table describes third-party known issues:
CR
Description
CCON-29725
When you configure a lookup transformation to read data from a column DataTime data type from a Google BigQuery source and the year value is greater than 2200, the lookup returns null value.
Google ticket reference number: 25982960
CCON-19992
When you run a mapping to read data of timestamp data type from a Google BigQuery source object, incorrect values are written to the target for certain timestamp values.
Google ticket reference number: 142002729
(October 2019)
CCON-18214
When you run a mapping to read a timestamp value of 10000-01-01 00:00:00 UTC from a Google BigQuery source object, the mapping fails.
Google ticket reference number: 134880537/19650976
(June 2019)


Updated February 11, 2021