CURRENT_SESSION_ARN
Returns the ARN of the currently authorized global user. Global users present with the same identity across Redshift accounts, clusters, and Serverless workgroups. Global users log in through IAM Identity Center, or through IAM-based session authentication. Data lake users are global AWS users.
This function is typically used in the context of using multi-dialect AWS Glue views. For more information about identity management with IAM Identity Center and Redshift, see Connect Redshift with IAM Identity Center to give users a single sign-on experience. For more information about multi-dialect Glue views Creating views in the AWS Glue Data Catalog.
Syntax
current_session_arn()
Return type
Returns a VARCHAR string of the globally authenticated user or a null value.
Usage notes
Local users aren't supported and result in a null response.
Example
The following query returns the name of the current session ARN:
SELECT current_session_arn();
current_session_arn
--------------
arn:aws:iam::123456789012:user/user
(1 row)