1
0
In traditional RDBMS , To clone an existing data warehouse and give a different set of users access to the environment. DBA have to create a whole new, separate, deployment of the environment. Creation of Snapshots generally results in consumption of more storage (which of course costs more $$). Snowflake Zero copy cloning does not copy the data it only creates a reference to the original Data.
Zero Copy Cloning is the capability to duplicate an object while neither creating a physical copy nor adding any additional storage costs. This allows for much greater freedom in the environment as costs are kept low without limiting potential.
When any form of internal stage is cloned (usually in the case of an internal table stage), it is vital to note that this stage will be empty. On a similar thread, cloned streams will also be empty and cloned pipes and tasks will by paused by default.
When a pipe is cloned, by default it will be paused. This is to avoid unnecessary data loading as a clone may not require additional data loading. This also allows the user to confirm the pipe will execute the correct action.
In Snowflake, can be done easily with just few commands.
Please follow the below quick link to describe one of the real time scenario :
Data cloning is helpful and worth and doing the cloning across the environment with ease.
https://lnkd.in/dMbz2wr
To get Cloning introduction, Click here .
