Jump to content
Changes to the Jaspersoft community edition download ×

Connecting Snowflake from Jaspersoft Studio


devendra.p

Recommended Posts

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

 

Link to comment
Share on other sites

  • 1 month later...
  • Replies 1
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...