Couldn't connect with red-shift database


#1

I need to connect my red-shift data source with redash.
below is the configuration details.

Type:    redshift
Name:   unilogsnowplow
Host:     jdbc:redshift://snowplow2.cze0fyuagv4x.us-east-1.redshift.amazonaws.com:5439/unilog2
Password:   xxxxx
User:      unilog2
Database Name:   unilog2
Port:   5439

when i am testing the connection it is giving below error message…

Connection Test Failed:
could not translate host name "jdbc:redshift://snowplow2.cze0fyuagv4x.us-east-
1.redshift.amazonaws.com:5439/unilog2" to address: Name or service not known

Please suggest what mistake i am doing here…


#2

Try just snowplow2.cze0fyuagv4x.us-east-1.redshift.amazonaws.com:5439/unilog2 for Host perhaps?
I can’t connect with jdbc:redshift:// either. W/o it works for me.


#3

Hey @tonyjiangh Even i tried with snowplow2.cze0fyuagv4x.us-east-1.redshift.amazonaws.com:5439/unilog2 but same error.

Connection Test Failed:
could not translate host name "snowplow2.cze0fyuagv4x.us-east-1.redshift.amazonaws.com:5439/unilog2" 
to address: Name or service not known

#4

Hey @sandesh
What about just snowplow2.cze0fyuagv4x.us-east-1.redshift.amazonaws.com.
I forgot that I didn’t put the port and db name there, sorry about that.
If that doesn’t work, I have no idea…


#5

hey @tonyjiangh
thank yo so very much for the quick reply…
Now it is working.