Hi,
Follow the below steps:
1. Click on Amazon red shift on the To a server.
2. Enter the server, username and password and database name details.
3. Click Sign in.
4. Enter or select the Schema.
5. Select the Table name from the table list.
6. Go to Sheet.
Hope this helps you.