Follow these steps, to connect to Amazon Redshift.
1. Click on Get Data.
2. Go to Database and select Amazon Redshift.
4. Then Type your server name and database name.
5. Type any Sql statements. (optional) and click ok
6. Select required tables and fields residing in Amazon Redshift database for creating your report and visualization.
7. Click Ok.
8. Now the data is retrieved and is ready to create visualizations.
Hope this helps you.