Redshift
To connect Redshift as a data source, you will need the following information:
Database: Name of the database.
Host: Host Endpoint of the Redshift Cluster (must include the cluster-id, region and end with .redshift.amazonaws.com).
Password: Password associated with the username.
Port: Port of the database.
Username: Username to use to access the database.
Note: It is recommended to create a dedicated read-only user with access to the relevant schemas.