- 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.
Syntax¶
SYSTEM$COMMIT_MOVE_ORGANIZATION_ACCOUNT( <grace_period> )
Arguments¶
grace_periodSpecifies 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);