DEFAULT_IAM_ROLE - Amazon Redshift
SyntaxReturn typeExample

DEFAULT_IAM_ROLE

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)