I answered the previous comment thinking of RDS... You can certainly add a note anywhere appropriate about RDS.

As for the original question of Redshift some have used the pg translator with the red shift driver, but there's been no full testing so another translator could be needed at some point.