Swap Databases

Swap the names of two Snowflake databases safely with object sync and grant mirroring. Also handles read-only databases by redirecting dependent objects from one DB to another without renaming. Also handles zerocopy swap of an imported datashare database with a catalog-linked database (CLD). Use when: swapping databases, renaming databases bidirectionally, blue-green database cutover, migrating database names, database name swap, redirecting dependencies, read-only database migration, shared database replacement, migrate shared views, redirect abstracted views, sfshares migration, zerocopy swap, datashare to CLD, imported database swap CLD. Triggers: swap databases, rename database, swap DB names, database cutover, blue-green swap, exchange databases, redirect dependencies, read-only database, replace shared database, migrate references, migrate sfshares, abstracted views, migrate views, zerocopy, datashare, catalog linked database, CLD, SYSTEM$ZEROCOPY_SWAP.

snowflake-labs Updated 54 repo stars

File contents

snowflake-labs/coco-skills commit e1dd4bdd4f

Frequently asked questions

npx get-skill add snowflake-labs/swap-databases