I am trying to load data into one of the table in redshift.So i have created a metadata connection for the db. It connected successfully.
Attaching the screenshot below for reference.
After the successful connection in metadata, I have extracted the same connection into job and tried testing connection. The connection was established and disconnected immediately with below error message
"DriverManager.getConnection
("jdbc:redshift://XXXXXXXX.redshift.amazonaws.com:5439/YYY?loglevel=1")
trying com.amazon.redshift.jdbc.Driver
getConnection returning com.amazon.redshift.jdbc.Driver "
Attaching screenshot below for the reference
Could