Google Cloud Platform Component Release Notes

This page lists the main features added to the Google Cloud Platform component.

Change Log

Version 2023.3.0

Bug Fixes

  • DI-7893: The error Access Denied is displayed when accessing an external table in BigQuery that points to a Google Drive Spreadsheet.

Version 2023.2.0

Bug Fixes

  • DI-7151: When the Google storage delivery repository is set in the engineParameters, the delivery name in the repository is incorrect.

  • DI-7268: Third-party library upgrade: org.json

Version 2023.1.15

Bug Fixes

  • DI-9774: Updated ThreeTen third-party libraries.

Version 2023.1.10

Bug Fixes

  • DI-9308: Fixed an issue which showed an error when creating an OAuth2 entry for login.microsoftonline.com.

Version 2023.1.8

Bug Fixes

  • DI-8154: TOOL GCS Put Blobs: When the Existing Blobs Behavior parameter is set to ignore, an empty file is created instead of the real file.

  • DI-8851: Update JSON third-party libraries.

Version 2023.1.6

Bug Fixes

  • DI-8231: Upgrade Jackson third-party library.

Version 2023.1.5

New Features

  • DI-8182: Third-Party library upgrade.

Bug Fixes

  • DI-8207: Google BigQuery mappings using Google Storage as temporary location are unexpectedly failing because of permission issues.

Version 2023.1.2

Bug Fixes

  • DI-7151: When the Google storage delivery repository is set in the engineParameters, the delivery name in the repository is incorrect.

  • DI-7268: Third-party library upgrade: org.json

Version 2023.1.1

Bug Fix

  • DI-7093: The hardcoded authentication mechanism has been removed from the code and the Google Application Default Credentials mechanism is used instead.

  • DI-7150: The build of deliveries fails if the path is not defined in the engineParameters.xml file.

Version 2023.1.0

New Features

  • DI-4919: The location used to run queries can now be changed using the jobsLocation parameter in the JDBC URL.

  • DI-5650: Log4j version 1 has been removed from the dependencies.

  • DI-5839: A retry mode has bee added to re-run the query when an internalerror or jobBackendError error message is returned.

  • DI-6041: Detailed information about the error is displayed when a Google Big Query job fails.

  • DI-6140: Multiple third-party libraries upgrade.

  • DI-6308: Credential values in memory can now be retrieved programmatically. This avoids storing and displaying the credential values in variables when using the string credentials mode.

  • DI-6309: The productCode() XPath function is now available.

Bug Fix

  • DI-6473: Multiple third-party libraries upgrade.

  • DI-6518: Jackson - Third-party library upgrade.

Version 5.3.12 (Component Pack)

Bug Fixes

  • DI-7893: An Access Denied error is displayed when accessing an external table in BigQuery that points to a Google Drive spreadsheet.

  • DI-7981: Conversion issues with INT64, FLOAT64, BIGNUMERIC, DATETIME, and TIME data types cause SQLFeatureNotSupportedException errors when using Google BigQuery as a source.

  • DI-8207: Google BigQuery mappings that use Google storage as a temporary location fail unexpectedly because of permission issues.

Version 5.3.7 (Component Pack)

New Features

  • DI-6308: Add new capabilities to retrieve the credentials programmatically.

Version 5.3.6 (Component Pack)

New Features

  • DI-6041: Show detailed information about the error when a Google Big Query job fails.

  • DI-5839: Google BigQuery: add a retry mode to re-run automatically the query when an 'internalerror' or 'jobBackendError' error message is returned.

  • DI-4919: BigQuery: Add the ability to change the location used to run queries.

Version 3.0.1 (Component Pack)

New Features

  • DI-5178: Google Platform - support the externalization of the "Credentials String" authentication attribute

  • DI-5176: Google Platform - support the externalization of the "Credentials Mode" authentication attribute

Bug Fixes

  • DI-5177: Google Platform - tech:credentialsFile() xpath function should automatically replace "\" by "/" to avoid unexpected errors on scripting actions

Version 3.0.0 (Component Pack)

New Features

  • DI-3701: Allow Components to contribute to Designer monitored statistics

  • DI-4508: Update Components and Designer to take into account dedicated license permissions

  • DI-4731: Rebranding: Template messages

  • DI-4962: Improved component dependencies and requirements management

Version 2.2.0 (Google Platform Component)

New Features

  • DI-1178: Process Palette - New tool "TOOL GCS Create Folder" to create empty folders

  • DI-3713: Internal change on how some libraries are built to ease maintenance

Bug Fixes

  • DI-3331: Google Cloud Storage and Google BigQuery wizards - When launching the wizard on an existing Metadata, the first step of the wizard did not automatically select the account defined in Metadata

Version 2.1.0 (Google Platform Component)

New Features

  • DI-3510: EMF compare utility - Component has been updated to support EMF Compare comparison utility

Bug Fixes

  • DI-1165: Template - "INTEGRATION Bigquery" and "Load Rdbms to BigQuery" - SQL_STAT_INSERT and SQL_STAT_UPDATE statistics were not computed and not displayed

  • DI-1277: Google BigQuery - When loading DATE (or TIME) type from Bigquery into some databases (such as PostgreSQL) an error such as the following could unexpectedly be thrown "l1_c_time is of type time without time zone but expression is of type character varying"

  • DI-3833: Google BigQuery - Randomly, the "EngineExceptionI: A class was not found in the engine" error was displayed even when the Module was complete, because there was an unexpected jar in the Module which caused conflicts, and which has now been removed

Version 2.0.5 (Google Platform Component)

New Features

  • DI-1052: The isRepeated attribute was not reversed in the metadata, to use repeated fields.

  • DI-3392: Metadata Variables - Added support of Metadata Variable in BigQuery

Bug Fixes

  • DI-2059: BigQuery Reverse - Could not reverse a dataset containing partitioned tables "No enum constant"

  • DI-3565: Template - INTEGRATION BigQuery - SQL_STAT_INSERT and SQL_STAT_UPDATE statistics were not displayed

Version 2.0.4 (Google Platform Component)

New Features

  • DI-1944: Support a new authentication mode named "applicationDefault" which searches for authentication credentials in the current environment automatically through default Google’s mechanism

  • DI-1945: Google Cloud Platform Metadata - rename "Credential" level to "Account" for clarity