https://docs.snowflake.com/en/user-guide/account-replication-config#label-enabling-accounts-for-replication
To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account.
D
https://docs.snowflake.com/en/user-guide/account-replication-config
Enable Replication for Accounts in the Organization
The organization administrator (ORGADMIN role) must enable replication for the source and target accounts.
To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account.
Log into an ORGADMIN account to enable replication for each source and target account in your organization.
USE ROLE ORGADMIN;
-- View the list of the accounts in your organization
-- Note the organization name and account name for each account for which you are enabling replication
SHOW ORGANIZATION ACCOUNTS;
-- Enable replication by executing this statement for each source and target account in your organization
SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('<organization_name>.<account_name>', 'ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true
The organization administrator (ORGADMIN role) must enable replication for the source and target accounts before replicating a database
https://docs.snowflake.com/en/user-guide/database-replication-config#
To enable replication for accounts, a user with the ORGADMIN role uses the SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER function to set the ENABLE_ACCOUNT_DATABASE_REPLICATION parameter to true. Note that multiple accounts in an organization can be enabled for replication from the same ORGADMIN account.
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Rajivnb
7 months, 1 week agosinghks
9 months agoZaaju
9 months, 1 week agoMultiCloudIronMan
10 months, 1 week agoMultiCloudIronMan
10 months, 1 week agorokr87
1 year agorokr87
1 year agoisolated_sniper
1 year agobee5k
1 year ago