Snowflake Solutions Expertise and
Community Trusted By

Enter Your Email Address Here To Join Our Snowflake Solutions Community For Free

Snowflake Solutions Community

Replication not enabled for your account. Please contact Snowflake support for more information.

7.22K viewsData Architecture
0

How can I fix this freaking replication error on my Snowflake Secondary Account? I'm trying to create a replica and it seems that on this account which I enabled from the primary that replication is not enabled somehow.
Replication not enabled for your account. Please contact Snowflake support for more information.

I've searched everywhere and I cannot find others with this error.

Frank Bell Answered question September 22, 2022
1

Hey Charlie - This is definitely an annoying "gotcha". The problem is that on the secondary account itself where the Replica Database will be created has to be ENABLED for REPLICATION currently by ONLY the ROLE of ORGADMIN. So either you need to do this if you have access to ORGADMIN role. Or you need to find your ORGADMIN for your account and execute the following code:

Make sure to use your very own:
ORG_NAME and SECONDARY_ACCOUNT_NAME (where you will put the replica)


USE ROLE ORGADMIN;
SELECT SYSTEM$GLOBAL_ACCOUNT_SET_PARAMETER('ORG_NAME.SECONDARY_ACCOUNT_NAME','ENABLE_ACCOUNT_DATABASE_REPLICATION', 'true');
/*. ALSO, RESULT SHOULD BE:
[ "SUCCESS" ]
*/

ONLY after you do that will you be able to create a replica of the primary database on your secondary account.

Frank Bell Answered question September 22, 2022

Sign in with google.com

To continue, google.com will share your name, email address, and profile picture with this site.

Harness the Power of Data with ITS Solutions

Innovative Solutions for Comprehensive Data Management

Feedback on Q&A