It should work with redshift (see here for an example: AWS Redshift using Postgres fails to connect)
What do you have in the host field? You should only need sever.redshift.amazonaws.com:5439 and then the user field should contain the username and the password field should contain the password.
Grafana builds the connection string from the fields.