For this tutorial, you will need the following:
An AWS account – To access any web service that AWS offers, you must first create an AWS account at https://aws.amazon.com/.
Verified email address – To send emails using Amazon SES, you must verify your "From" address or domain to show that you own it. If you are in the sandbox, you also must verify your "To" addresses. You can verify email addresses or entire domains, but this tutorial requires a verified email address so that you can send an email from the Amazon SES console, which is the simplest way to send an email. For information about how to verify an email address, see Verifying Email Addresses in Amazon SES.
A SQL query tool – Amazon Redshift does not provide or install any SQL client tools or libraries, so you must install one that you can use to access the Amazon Redshift clusters that contain your Amazon SES events. In this tutorial, we use SQL Workbench/J, a free, DBMS-independent, cross-platform SQL query tool. The following steps show you were to go to install it.
The following procedure shows how to install SQL Workbench/J.
To install SQL Workbench/J on Your Client Computer
Review the SQL Workbench/J software license.
Go to the SQL Workbench/J website and download the appropriate package for your operating system.
Go to Installing and starting SQL Workbench/J and install SQL Workbench/J.
Note the Java runtime version prerequisites for SQL Workbench/J and ensure you are using that version. Otherwise, this client application will not run.
Go to Configure a JDBC Connection and download an Amazon Redshift JDBC driver to enable SQL Workbench/J to connect to your cluster.