README-drop-source-db-sec

Drop SOURCE_DB and SEC — Blocker

Status: Blocked by replication relationship.

Error: Share 'FEMA_SHARE' is currently a primary share in a replication relationship and cannot be dropped.

Prerequisites

Before running drop-source-db-sec-internal.sql:

1. Promote or drop secondary shares in the replication relationship involving FEMA_SHARE.
2. Or drop all secondary shares before dropping FEMA_SHARE.

Check replication status:

SHOW REPLICATION DATABASES;
SHOW REPLICATION GROUPS;

Share names (verified 2026-03-02)

Share	Database
FEMA_SHARE	SOURCE_DB
SOURCE_DB_SNOWFLAKE_SECURE_SHARE_1703260217333	SOURCE_DB
SEC_SNOWFLAKE_SECURE_SHARE_1710872475340	SEC
SEC_SNOWFLAKE_SECURE_SHARE_1711566275765	SEC

After resolving replication

snow sql -c brainforge-internal -f knowledge/engineering/data-platform/scripts/drop-source-db-sec-internal.sql

Data is already cloned to RAW per move-dbs-into-raw.sql.