Categories:

Context Functions (General)

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()

Arguments

None.

Examples

Show the current region:

SELECT CURRENT_REGION();

Output:

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

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

SELECT CURRENT_REGION();

Output:

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