When connecting to Google BigQuery using the Google BigQuery (JDBC) connector, the following error may occur:
Error Code: B19090E0
[Simba][BigQueryJDBCDriver](100004) HttpTransport IO error : javax.net.ssl.SSLHandshakeException: PKIX path building failed: sun.security.provider.certpath.SunCertPathBuilderException: unable to find valid certification path to requested target.
Unable to connect to the Google BigQuery (JDBC) server "". Check that the server is running and that you have access privileges to the requested database.
When SSL inspection is configured in the network environment, the JDBC driver may need to be configured to use the certificate when connecting to Google BigQuery.
This error indicates the presence of a VPN/Proxy between Tableau and Google BigQuery. Please review the options below to configure SSL and/or add missing proxy configurations.
Option 1:
Configure SSL for JDBC Connections
https://help.tableau.com/current/pro/desktop/en-us/jdbc_ssl_config.htm
Option 2:
If there's a proxy in the environment, then add the ProxyHost and ProxyPort driver parameters to the .properties file.
Option 3:
Add SSL Cert to Java Keystore
https://help.tableau.com/current/pro/desktop/en-us/config_proxy_oauth.htm#ssl-handshake-errors
Magnitude Simba Google BigQuery JDBC Data Connector
Disclaimer: The above links take you outside of salesforce.com. Although we make every effort to ensure links to external websites are accurate, up to date, and relevant, Tableau cannot take responsibility for the accuracy or freshness of pages maintained by external providers. Contact the external site for answers to questions regarding its content.
001475451
0 KB

We use three kinds of cookies on our websites: required, functional, and advertising. You can choose whether functional and advertising cookies apply. Click on the different cookie categories to find out more about each category and to change the default settings.
Privacy Statement
Required cookies are necessary for basic website functionality. Some examples include: session cookies needed to transmit the website, authentication cookies, and security cookies.
Functional cookies enhance functions, performance, and services on the website. Some examples include: cookies used to analyze site traffic, cookies used for market research, and cookies used to display advertising that is not directed to a particular individual.
Advertising cookies track activity across websites in order to understand a viewer’s interests, and direct them specific marketing. Some examples include: cookies used for remarketing, or interest-based advertising.