Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

Having problems connecting to snowflake from Pentaho? Any suggestions?

7.16K viewsErrors and Troubleshooting
0

Having problems connecting to snowflake from Pentaho? Any suggestions?

Gisele Casillas Answered question December 28, 2021
0

First you want to make sure that the Pentaho version is the 6.1 version or above.

Next, these steps will help you create the JDBC connection to Snowflake through Pentaho:

1. You will need to download the Snowflake JDBC driver to the workstation while at the same time running Pentaho
2. Then you will copy Snowflake_jdcb.jar to the Pentaho folder:

-On Windows this will be: C:\ProgramFiles\pentaho\design-tools\data-integration\lib
-On Mac OS this will be: …/pentaho/design-tools/data-integration/lib

3. Lastly, you will configure a Generic Database connection within Pentaho through:
Url: jdbc:snowflake://.snowflakecomputing.com:443/
Driver Class Name: net.snowflake.client.jdbc.SnowflakeDriver

Gisele Casillas Answered question December 28, 2021
You are viewing 1 out of 1 answers, click here to view all answers.

Maximize Your Data Potential With ITS

Feedback on Q&A