Host: The host name or IP address of your Redshift server.
Port: The port that Redshift is listening to. The default Redshift port is 5439, but it might be different in order to enhance security.
User: The username for the database.
Password: The password for the preceding User field.
SSL Mode:prefer; Redshift supports SSL connections. The default value for SSL Mode is prefer, which means that if SSL is available, the connection will use it, otherwise the connection will be made without SSL. As Redshift supports SSL, SSL is used when SSL Mode is set to prefer. For additional SSL Mode values, refer to the Redshift manual or consult your DBA.