Warehousing: Getting Started - Redshift - Step 3

This page will take you through associating IAM Role and running an External Schema Command.

1. Go into Amazon Redshift service in the AWS Console.

2. Select your Redshift cluster from the Provisioned Clusters Dashboard.

3. Go to the properties tab inside your Redshift cluster.

4. Scroll down to the Cluster Permissions section and click on Manage IAM Roles and then select Associate IAM Roles.

5. Select the “RockerboxRedshiftRole” that you previously created in the pop up window and then click on Associate IAM Roles.

6. Wait for the role to sync in the Associated IAM Roles list under Cluster Permissions section.

7. Scroll to the top of the page and click on “Go to query editor v2” on the right side of the page.

8. Copy the External Schema Statement displayed on your Redshift Setup UI and paste it into the query editor.

Data should now be available in the Rockerbox schema.