KNOWLEDGE BASE

Internet communication error: SSL peer certificate or SSH remote key was not OK (bigquery.googleapis.com)


Published: 28 Sep 2021
Last Modified Date: 29 Sep 2021

Issue

When connecting to Google Big Query from Tableau Desktop, 
the error occurs:

"Internet communication error: SSL peer certificate or SSH remote key was not OK <server name or IP>" or "Internet communication error: Peer certificate cannot be authenticated with given CA certificates (<server name>)".

It is not possible to connect to Google BigQuery from Tableau Desktop once there is an SSL error.

Environment

  • Tableau Desktop
  • Google BigQuery

Resolution

If the certificates are not being populated to the Windows Certificate, they will need to be manually added. For that, launch Tableau Desktop, select Google BigQuery connector, from the webpage open, download the new certificate (GTS Root R1, and GTS CA 1C3) and manually install them on "Trusted Root Certification Authorities" and "Intermediate Certification Authorities" respectively.
 

Cause

Google has updated their certificate and the computer is not getting the certificate installed when authenticating to Goggle BigQuery
Did this article resolve the issue?