GET_MOUNTED_ROLE - Amazon Redshift
SyntaxReturn typeUsage notesExample

GET_MOUNTED_ROLE

When invoked as part of a multi-dialect AWS Glue view, it allows returning the IAM role used to mount the Lake Formation schema or database. Multi-dialect means that the SQL is supported across multiple query engines, such as Amazon EMR and Redshift. For more information about multi-dialect Glue views, see Creating views in the AWS Glue Data Catalog.

Syntax

get_mounted_role()

Return type

Returns a VARCHAR string or a null value.

Usage notes

This function returns null for any use case outside of an external Lake Formation view.

Example

The following query returns the identity to mount the Lake Formation resource.

CREATE EXTERNAL PROTECTED VIEW external_schema.remote_view AS 
SELECT mycol, get_mounted_role() FROM external_schema.remote_table;

mycol | get_mounted_role
----------------------------
1       arn:aws:iam::123456789012:role/salesrole
(1 row)