Categories:

System functions (System Control)

SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT

Finalizes the process of moving an organization account from one region to another.

The process of moving the organization account began when the SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT was called.

See also:

SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT , SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS

Syntax

SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT( <grace_period> )
Copy

Arguments

grace_period

Specifies the number of days after which the organization account in the original region (that is, the source region) will be deleted.

Access control requirements

Only users with the GLOBALORGADMIN role can call this function.

Usage notes

  • You are automatically logged out of Snowflake immediately after calling this function.

  • Until the process of finalizing the move completes (usually within a few minutes), you cannot sign in to the organization account in the source region nor the organization account in the target region.

  • When the finalization process completes, the name of the organization account in the new region changes from the temporary name that was specified by the SYSTEM$INITIATE_MOVE_ORGANIZATION_ACCOUNT function to the original name of the organization account.

  • To check the status of the finalization process, call the SYSTEM$SHOW_MOVE_ORGANIZATION_ACCOUNT_STATUS function.

Examples

Delete the original organization account 14 days after the move is finalized:

SELECT SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT(14);
Copy
Language: English