Connecting Snowflake from Jaspersoft Studio

0

Hi There,
We are for the first time trying to make connection to Snowflake account through TIBCO Jaspersoft® Studio Professional 7.1.0.

Client has provided us:
1. Username and Password,
2. JDBC URL: jdbc:snowflake://<my_server_ip>.snowflakecomputing.com/?account=<myaccount>&warehouse=query_nonprod
3. JAR file: snowflake-jdbc-3.6.9.jar

From Jaspersoft Studio, I tried to create new data adaptor following below steps.
1. Used below three JDBC driver names one by one.
2. Entered above provided JDBC URL, and credentials.
3. In Driver Classpath added the path of JAR file.

I received below error messages with each JDBC Driver:

I. JDBC DRIVER: cdata.jdbc.snowflake.SnowflakeDriver
=========================================================================================================================================================
net.sf.jasperreports.engine.JRRuntimeException: java.lang.ClassNotFoundException: cdata.jdbc.snowflake.SnowflakeDriver cannot be found by net.sf.jasperreports_7.1.0.final
Caused by: java.lang.ClassNotFoundException: cdata.jdbc.snowflake.SnowflakeDriver cannot be found by net.sf.jasperreports_7.1.0.final

II. JDBC DRIVER: com.snowflake.client.jdbc.SnowflakeDriver
==========================================================================================================================================================
net.sf.jasperreports.engine.JRException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver not able to connect to Snowflake. Error code: 390188, Message: User's configured default role 'PPD_POC_PUBLIC_USER_ROLE' does not exist. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another role, e.g. PUBLIC..

Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver not able to connect to Snowflake. Error code: 390188, Message: User's configured default role 'PPD_POC_PUBLIC_USER_ROLE' does not exist. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another role, e.g. PUBLIC..

III. JDBC DRIVER: net.snowflake.client.jdbc.SnowflakeDriver
===========================================================================================================================================================
net.sf.jasperreports.engine.JRException: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver not able to connect to Snowflake. Error code: 390188, Message: User's configured default role 'PPD_POC_PUBLIC_USER_ROLE' does not exist. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another role, e.g. PUBLIC..
 
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: JDBC driver not able to connect to Snowflake. Error code: 390188, Message: User's configured default role 'PPD_POC_PUBLIC_USER_ROLE' does not exist. Contact your local system administrator, or attempt to login using a CLI client with a connect string selecting another role, e.g. PUBLIC..

Regards,

Devendra Jakhmola

 

devendra.p's picture
Joined: Sep 25 2017 - 6:47am
Last seen: 12 months 4 days ago

Hi,

I have a similar requirement to connect to the snowflake database from Jaspersoft studio. Is your issue resolved? Can you guide on the correct steps here?

Regards,

Siddhi

siddhi_doshi - 10 months 2 weeks ago

0 Answers:

No answers yet
Feedback