search

coursera / dataduct

DataPipeline for humans.
Other
252 stars 83 forks source link

Using Redshift Clusters in Different Regions #248

Open josheschulz opened 8 years ago

josheschulz commented 8 years ago

I'm trying to use a redshift cluster in a different region using the optional "Region" Field on my RedshiftDatabase but I can't figure out how to set it via the config (the naive REGION: us-west-1 under redshift doesn't work).

Is it possible?

seguschin commented 8 years ago

I changed in redshift_database.py (line 15&28) to use connection_string instead of cluster_id, and same in the config. On line 15 ()inserted) i defined CONNECTION_STRING = config.redshift['CONNECTION_STRING'] on line 28 i replaced cluster_id=CLUSTER_ID, with connection_string=CONNECTION_STRING,

same CONNECTION_STRING defined in config file (jdbc url).

eldhosejohn commented 7 years ago

Thanks @josheschulz @seguschin. Please see the PR #255