Google News
logo
Snowflake - Interview Questions
What is Zero-copy cloning in Snowflake?
It is an implementation that enables us to create a copy of tables, schemas and databases without actually copying the data. For performing zero-copy in Snowflake, we must use a keyword named CLONE. This option allows you to obtain real-time data from production and carry out several actions.

Advantages :
 
* There are no additional storage costs associated with data replication.
* There is no waiting time for copying data from production to non-production contexts.
* There is no need for administrative efforts since cloning is as simple as a click of a button. 
* No copy, only clone: Data exists only in one place.
* Promote corrected/fixed data to production instantly.
Advertisement