Support Questions

Find answers, ask questions, and share your expertise
Announcements
We’ve updated our product names and community labels - click here for full details

The connection between NiFi and Snowflake failed when tried conneting using service userid and password

avatar
Explorer

Below is the snowflake connection url from NiFi:
jdbc:snowflake://<account>.snowflakecomputing.com/?db=<db>&schema=<schema>&warehouse=<wareeehouse>
user: <userid>
password: <password>

Driver Class Name: net.snowflake.client.jdbc.SnowflakeDriver
Driver Loaction: E:\pimnifi\nifi-libs

I m getting below error:
Cannot create PoolableConnectionFactory (Incorrect username or password was specified.)
Caused by: java.sql.SQLException: Cannot create PoolableConnectionFactory (Incorrect username or password was specified.)
Caused by: net.snowflake.client.jdbc.SnowflakeSQLException: Incorrect username or password was specified.. No FlowFile to route to failure: {}

Please help me in solving this error.

1 REPLY 1

avatar
Community Manager

 @NaveenSagar Welcome to the Cloudera Community!

To help you get the best possible solution, I have tagged our NiFi experts @MattWho @SAMSAL  who may be able to assist you further.

Please keep us updated on your post, and we hope you find a satisfactory solution to your query.


Regards,

Diana Torres,
Senior Community Moderator


Was your question answered? Make sure to mark the answer as the accepted solution.
If you find a reply useful, say thanks by clicking on the thumbs up button.
Learn more about the Cloudera Community: