Zero Copy Cloning in snowflake cloud data warehouse
What is Zero-Copy Cloning: Snowflake cloning is a meta data-only related operation only, there is no physical data copied from one environment to another, clone data point out to the actual database and further CRUD operations keep separately in new environment which do not effect the old data, it is important to note that there is no data movement during a clone operation, only creation of new meta data. The meta data for these new database objects simply point back to the original source data. There is no additional cost when creating a clone. You will incur the cost of storage when DML ops is applied to the cloned data. Create a clone of the table: CREATE OR REPLACE TABLE demo_db.public.employees_clone CLONE employees; Create a clone of the database: CREATE or replace DATABASE demo_db_clone CLONE demo_db; Clone objects are writable and is independent from clone source database, changes made on either cloned object or source object are not a part...