Which are characteristics of data replication in Snowflake?
A primary database is enabled for replication from its source account by using ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS. The initial and subsequent synchronization of a secondary database is performed in the target account with ALTER DATABASE ... REFRESH. An account can designate any number of databases as primary databases, and each primary database can be replicated to any number of accounts within the same organization. Database replication also supports different regions and cloud platforms; databases created from shares cannot be replicated.
ALTER DATABASE ... ENABLE REPLICATION TO ACCOUNTS
ALTER DATABASE ... REFRESH
Community Discussion