3424000 - SAP Datasphere issue with BQ Google Connection

Symptom

You have created connection to Google BigQuery via SAP HANA Smart Data Access (using HTTP-based REST APIs) according to SAP Help:
https://help.sap.com/docs/SAP_DATASPHERE/9f804b8efa8043539289f42f372c4862/46f5467adc5242deb1f6b68083e72994.html

Although the single certificate for Google was uploaded into SAP Datasphere path: System->Configuration->Security, the connection failed with error:

Remote tables can’t be used because of errors in the connection.
Remote Tables: Could not establish a secure connection because the server certificate couldn’t be validated. Please upload the certificate of the server or the certificate of the signing authority (CA). If you’re not authorized, please contact your administrator.

Environment

SAP Datasphere

Reproducing the Issue

Validate the Google BigQuery Connection.

Resolution

Please download the Google root certificate, not the intermediate certificate or the server certificate.

In the browser, open https://cloud.google.com/ and export the GTS Root R1 certificate which is valid until 2036. Then upload in Datasphere (System -> Configuration -> Security), and the Google BigQuery connection should validate successfully.

Keywords

KBA , DS-DI-CON , Connections , How To

Product

SAP Datasphere all versions