Deploying a Redshift cluster

Let's start by deploying our Redshift cluster, before configuring Redshift Spectrum to access data in S3:

1. Log into the AWS console and navigate to Amazon Redshift.
2. Select Create cluster.
3. Enter a name for your cluster and, if available, select the Free trial option:

Figure 7.4 – Redshift cluster creation

4. Enter a password and click Create cluster.
5. The console will now show a connection screen, explaining how to connect to your cluster, as well as the cluster's status at the bottom:

Figure 7.5 – Redshift dashboard

When the cluster appears as Available, we can configure Redshift Spectrum.

Configuring Redshift Spectrum

Amazon hosts test data in a public S3 database. We will use that in this lab. We can access it using Redshift Spectrum. To configure Redshift Spectrum, we need to complete three tasks:

• Configure an IAM role – we will...