Categories:

System functions (System Control)

SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION

Sets the event account for a region.

See also:

SYSTEM$UNSET_EVENT_SHARING_ACCOUNT_FOR_REGION

Syntax

SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION( '<snowflake_region>' , '<region_group>' , '<account_name>' )
Copy

Arguments

snowflake_region

Specifies the region where the account is located, for example: AWS_US_WEST_2, AWS_US_EAST_1.

region_group

Specifies the region group, for example: PUBLIC. Refer to Region groups for details.

account_name

Specifies the account name. If another account is already set as the events account in the specified region, calling this function changes the events account to be the account specified here.

Access control requirements

  • Only users with the ORGADMIN role can execute this SQL function.

Examples

SELECT SYSTEM$SET_EVENT_SHARING_ACCOUNT_FOR_REGION('aws_us_west_2', 'public', 'myaccount');
Copy
Language: English