Categories:

System functions (System Control)

SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT¶

Starts the process of moving an organization account to a new region.

See also:

SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT , SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS

Syntax¶

SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT(
    '<temp_name>' ,
    '<region>' ,
    { 'ALL' | '<object> [, <object> ...]' } )
Copy

Arguments¶

'temp_name'

Specifies a temporary account name by which the organization account in the new region can be identified until the move is finalized.

The name of the organization account in the new region changes from this temporary account name to the name of the original organization account when the SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT function finishes successfully.

'region'

Snowflake Region ID of the region where the organization account will be moved.

{ 'ALL' | 'object [, object ...]' }

List of objects that will be moved to the organization account in its new region. Because Snowflake uses replication groups to move the objects, you can only move objects that are supported by replication groups, which varies depending on your Snowflake edition. For a list of objects that can be moved, see Replicated objects.

To move all objects that can be replicated, specify ALL.

Access control requirements¶

Only users with the GLOBALORGADMIN role can call this function.

Usage notes¶

  • You cannot sign in to the organization account in the new region until the initiation process is complete. To check the status of the process, call the SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS function.

  • After the initiation process completes, you can sign in to the organization account in the new region using its temporary name, but cannot execute any SQL statement other than SELECT, USE, and SHOW.

Examples¶

SELECT SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT('temp_acct', 'aws_us_west_2', 'ALL');
Copy
Language: English