Services or capabilities described in Amazon Web Services documentation might vary by Region. To see the differences applicable to the China Regions, see Getting Started with Amazon Web Services in China (PDF).

GET_MOUNTED_ROLE

When invoked as part of a multi-dialect Amazon 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 Amazon 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)