3424000 - SAP Datasphere issue with BQ Google Connection

You have created connection to Google BigQuery via SAP HANA Smart Data Access (using HTTP-based REST APIs) according to SAP Help Documentation: Manage Certificates for Connections.

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.

SAP Datasphere

Validate the Google BigQuery Connection.

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 and GTS Root R4 certificate which is valid until 2036. Then upload in Datasphere (System -> Configuration -> Security), and the Google BigQuery connection should validate successfully.

KBA 3567141 - SDA remote source Google Big Query connection failure due to SSL certificate validation error in SAP Datasphere

BigQuery, BQ, Datasphere, remote, certificate, validation, SSL , KBA , DS-DI-CON , Connections , How To