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.