- Newest
- Most votes
- Most comments
Update:
I tried this external table setup in a regular redshift cluster (not a serverless one), and it works, after I do associate the role used to the cluster. For redshift serverless though, I do not see any clusters to attach the role to.
So even if the error says: "The requested role ... is not associated to cluster", there is no "cluster" to associate the role to, when running a serverless instance.
To corroborate that, I run:
aws redshift describe-clusters
And I got an empty response:
{ "Clusters": [] }
So I guess the questions is: is it possible (given the error), to associate a role to a clusterless redshift, as in when it runs serverless?
or:
Has anybody been able to create an external table in a redshift serverless instance? is that not supported?
Hi Ramiro,
Have you already added the IAM role to the Redshift Serverless namespace? If not, add it and then try to re-execute your command.
Go to the Redshift Serverless console => Namespace configuration => Click on the appropriate namespace => Security and Encryption tab => Manage IAM Roles => Associate the IAM Role => Save changes.
Thanks.
Relevant content
- asked 3 years ago
- asked 6 years ago
- Accepted Answerasked a year ago
- AWS OFFICIALUpdated 2 years ago
- AWS OFFICIALUpdated 2 years ago