Skip to content

Replication

This tutorial will show how to replicate your data from one Snowflake account to anther.

Video

Video is still in development.

Requirement

  • You will need to be an account admin and orgadmin role.
You will need to enable orgadmin role to see the account page under the admin page. 
1
2
3
4
5
6
7
use role accountadmin;

-- (option 1) grant the orgadmin role to a user.
grant role orgadmin to user <username>;

-- (option 2) grant orgadmin to a role.
grant role orgadmin to role <role>;

Walk Through

First we'll want to enable the other account to be able to replicate to. Please put in your orginization name and account name.

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
-- If you do not have this role please read warning above.
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. You will use it in the next command.
*/

show accounts;

--  Enable replication for the source account.
select system$global_account_set_parameter(
    '<orginization>.<account name>',
    'enable_account_database_replication',
    'true'
);

--  Enable replication for the target account.
select system$global_account_set_parameter(
    '<orginization>.<account name>',
    'enable_account_database_replication',
    'true'
);

1
Result.

Next navigate to the account page and select replication and finally "+ group". Account page

Select the account you enabled. Navigate

Once selected you will want to login to confirm the connection of the other account. Navigate

Once logged in you will see it being succesful. Navigate

Next we'll want to name the replication, select the objects to replicate and a replication frequency. Navigate

Once you click create you will begin the replication process. Once it's replicated you will recieve metrics about how much has been replicated. Navigate