Redshift
Canvas requires a few fields in order to connect to your Redshift instance:
Host
Port
Database
Username and Password
We'll go through each of these.
Host
The public address of your Redshift instance. You can find this in the AWS console. Note that you might need to check Enable Public Access
from the AWS console. Additionally, if you block public access to your database you will need to whitelist the following IP addresses in your database's security group:
44.224.89.3
35.80.194.138
44.241.79.133
Port
Also available in the AWS console. This is 5439
by default.
Database
The database that you would like to work with in Canvas.
Username and Password
Last updated
Was this helpful?