Support Questions

Find answers, ask questions, and share your expertise

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: