Skip to main content
Announcements
SYSTEM MAINTENANCE: Thurs., Sept. 19, 1 AM ET, Platform will be unavailable for approx. 60 minutes.
cancel
Showing results for 
Search instead for 
Did you mean: 
Prateekk
Contributor
Contributor

Issue connecting to redshift from tredshiftconnection component

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.
 
0683p000009M97E.jpg
 
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 
 
0683p000009M98G.jpg
Could
Labels (1)
1 Reply
Anonymous
Not applicable

can you upload a screenshot of basic settings of tRedshiftConnection component?