What can Snowflake use to create a copy of a table without incurring storage costs?
Snowflake zero-copy cloning initially shares the original table’s underlying micro-partitions with the cloned table, so creating the clone uses no additional data storage. Storage is added only for subsequent changes that create clone-specific data. Snowflake documentation
Community Discussion