Cannot connect to Amazon Redshift
Error
[Amazon](500310) Invalid operation: no pg_hba.conf entry for host user SSL off;
More like,
[Amazon](500310) Invalid operation: no pg_hba.conf entry for host “::ffff:x.x.xxx.xxx”, user “the_user”, database “the_database”, SSL off;
In the Driver properties had to set
AuthMech=REQUIRE SSL=TRUE
Yay, it worked!!