Returns the default IAM role currently associated with the Amazon Redshift cluster. The function returns none if there isn't any default IAM role associated.
Syntax
select default_iam_role();Return type
Returns a VARCHAR string.
Example
The following example returns the default IAM role currently associated with the specified Amazon Redshift cluster,
select default_iam_role();
default_iam_role
-----------------------------------------------
arn:aws:iam::123456789012:role/myRedshiftRole
(1 row)