CURRENT_REGION¶

Returns the name of the region for the account where the current user is logged in.

For organizations that have accounts in multiple region groups, returns region_group.region.

Syntax¶

CURRENT_REGION() 

Copy

None.

Show the current region:

SELECT CURRENT_REGION(); 

Copy

Output:

+------------------+ | CURRENT_REGION() | |------------------| | AWS_US_WEST_2 | +------------------+ 

Copy

Show the current region when the current user is logged into an account in an organization that spans multiple region groups:

SELECT CURRENT_REGION(); 

Copy

Output:

+----------------------+ | CURRENT_REGION() | |----------------------| | PUBLIC.AWS_US_WEST_2 | +----------------------+ 

Copy