To connect to Amazon Redshift:
Step 1. Select "Amazon Redshift" from the New Source menu; the connection dialog for an Amazon Redshift database will appear.
Step 2. Provide Server URL (the endpoint of the Amazon Redshift cluster).
Note: Sign in to the AWS Management Console and open Amazon Redshift console at console.aws.amazon.com/redshift/. In the left navigation pane, click Clusters, and then click your cluster. Under Cluster Database Properties of your cluster, copy the endpoint part from the JDBC URL of the cluster.
For example, your JDBC URL could look like this: jbbc:redshift://examplecluster.us0I3nrnge4i.us-west-2.redshift.amazonaws.com:5439/dev. Copy the endpoint part: examplecluster.us0I3nrnge4i.us-west-2.redshift.amazonaws.com
Step 3: Provide your database name.
Step 4: Provide your security credentials.
Click "OK" to connect to the Redshift Database.
Step 5: Write an SQL query to get the data.