title: Error connecting to database: (using class net.snowflake.client.jdbc.SnowflakeDriver)
body: <p>I have used Pentaho 8.2 community edition in CentOs operating system. The SnowFlake driver version used is 3.9.2. But when we try to fetch data from ktr using Pentaho it gives below-mentioned error. Please help.</p>
  
  <pre><code>An error occurred, processing will be stopped:
  Error occurred while trying to connect to the database
  Error connecting to database: (using class net.snowflake.client.jdbc.SnowflakeDriver)
  JDBC driver encountered communication error. Message: Exception encountered for HTTP request: java.security.cert.CertificateException: Failed to find the root CA..
  2019/11/27 03:34:18 - TI_XREF_SHIPS_LEADS_SALES_FILE.0 - ERROR (version 8.2.0.0-342, build 8.2.0.0-342 from 2018-11-14 10.30.55 by buildguy) : Error initializing step [TI_XREF_SHIPS_LEADS_SALES_FILE]
  </code></pre>
  
  <p>I also installed certificate with below command and restarted pentaho server. still the same erroe.
  <code>java InstallCert ******.us-east-1.snowflakecomputing.com:443</code></p>
  
  <p>Java Version used</p>
  
  <pre><code>java version "1.8.0_92"
  Java(TM) SE Runtime Environment (build 1.8.0_92-b14)
  Java HotSpot(TM) 64-Bit Server VM (build 25.92-b14, mixed mode)
  </code></pre>