Connect Redshift Spectrum to Glue Data Catalog
This page provides a guide on how to connect Redshift Spectrum to Glue Data Catalog.
Last updated
Was this helpful?
This page provides a guide on how to connect Redshift Spectrum to Glue Data Catalog.
Last updated
Was this helpful?
1. Sign in to the AWS console.
2. Open the IAM console at .
3. In the navigation pane, click Roles.
4. Click Create Role.
5. Select Redshift from the list of services.
6. In the Select your use case section, select Redshift > Customizable.
7. Click Next: Permissions.
8. Click Next: Tags.
9. Click Next: Review.
10. Enter a name for your role (e.g. redshiftSpectrumRole).
11. Click Create Role.
12. On the Roles page, look for the role just created (by name) and select it.
13. Select Add Inline Policy.
14. Select JSON Editing Option.
15. Paste the following policy into the editor (clear the default base policy before pasting):
16. Click Review Policy.
17. Give a name to your policy (for example, redshiftSpectrum).
18. Click Create Policy.
19. Make a note of the role ARN and keep it handy - you will need this for the external schema creation.
21. Select CLUSTERS.
22. For each cluster that will use Redshift, click on the required cluster.
23. In the Cluster Properties section, select IAM roles.
24. Locate and select the role you created.
25. Click Apply changes.
1. Select a name for the policy, for example, redshiftSpectrum.
2. Select Create Policy.
3. Make a note of the role ARN (it is required for external schema creation).
5. Select Clusters.
6. Perform the following actions for each Redshift cluster on which you want to use
Redshift Spectrum:
Select the cluster.
In the Cluster Properties section, select See IAM roles.
Locate and select the previously created role name.
7. Click Apply Changes.
1. Run the following query in the cluster (this can be done either via the Query Editor section under the Redshift Management Console or via your favorite SQL editor).
3. In the navigation pane, select Permissions > Data permissions.
4. Provide the following information:
Prompt
Details
IAM role
Database
Select your Lake Formation database.
Table
Select a table within the database to query.
Columns
Select All Columns.
5. Select Select permission.
6. Click Save.
20. Open the Redshift console at .
4. Open the Redshift console at .
2. Open the Lake Formation console at:
Select the IAM role created, redshiftSpectrumRole, as the IAM role. The Amazon Redshift Query Editor uses this IAM role for permission to access the data. See: