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: 1 week 2 days ago

0 Answers:

No answers yet
Feedback
randomness