You can access the Amazon Redshift database by defining an EC2 role, where the EC2 instance can assume a role. To access Redshift, you must enable the

Use EC2 to Assume Role

check box in the connection properties and configure the permission and trust policies.

When you define the policies, identify the

Cluster Identifier

and

Database Name

values from the JDBC URL in the connection properties. For example, if the JDBC URL is

<jdbc:redshift://

infa-rs-qa-cluster

.czf3ijw5fo0z.us-west-2.redshift.amazonaws.com:5439/

rsqa

>

,

infa-rs-qa-cluster

is the cluster identifier and

<rsqa>

is the database name.