Warehousing: Getting Started - Redshift - Step 3
This page will take you through associating IAM Role and running an External Schema Command.
- Go into Amazon Redshift service in the AWS Console.
![associate-iam-role-external-schema_1.png 1917](https://files.readme.io/893e116-associate-iam-role-external-schema_1.png)
- Select your Redshift cluster from the Provisioned Clusters Dashboard.
![associate-iam-role-external-schema_2.png 1925](https://files.readme.io/bd742a8-associate-iam-role-external-schema_2.png)
- Go to the properties tab inside your Redshift cluster.
![associate-iam-role-external-schema_3.png 1921](https://files.readme.io/8d964da-associate-iam-role-external-schema_3.png)
- Scroll down to the Cluster Permissions section and click on Manage IAM Roles and then select Associate IAM Roles.
![associate-iam-role-external-schema_4.png 1917](https://files.readme.io/05181ff-associate-iam-role-external-schema_4.png)
- Select the “RockerboxRedshiftRole” that you previously created in the pop up window and then click on Associate IAM Roles.
![associate-iam-role-external-schema_5.png 714](https://files.readme.io/bf2398f-associate-iam-role-external-schema_5.png)
- Wait for the role to sync in the Associated IAM Roles list under Cluster Permissions section.
![associate-iam-role-external-schema_6.png 1230](https://files.readme.io/096521a-associate-iam-role-external-schema_6.png)
![associate-iam-role-external-schema_7.png 1228](https://files.readme.io/d1ae2c8-associate-iam-role-external-schema_7.png)
- Scroll to the top of the page and click on “Go to query editor v2” on the right side of the page.
![associate-iam-role-external-schema_8.png 1918](https://files.readme.io/5f041c0-associate-iam-role-external-schema_8.png)
- Copy the External Schema Statement displayed on your Redshift Setup UI and paste it into the query editor.
![associate-iam-role-external-schema_9.png 1918](https://files.readme.io/3b530fb-associate-iam-role-external-schema_9.png)
Data should now be available in the Rockerbox schema.
Updated about 2 years ago