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.
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.