# Zero-Copy Clone

> A fast copy of a table. It shares its files until one side changes.

**Field:** Data Engineering  
**Category:** Storage & Warehousing  
**Also known as:** Zero-Copy Cloning, Table Clone, Shallow Clone

## Think of it like

It is like a photocopy that only uses ink where you write on it. The rest still points at the first page.

## Definition

A zero-copy clone is a copy of a table, schema or database made without copying the data. The clone points at the same stored files as the source. New files are written only when one side changes rows. So a clone of a huge table is ready in moments and costs almost nothing at first. Snowflake can make one, and so can lake formats such as Delta Lake.

## Example

A team clones its 4 TB sales database each morning for testing. The clone is ready fast, and testers can change it without touching the real data.

## Example code

```sql
CREATE TABLE orders_test CLONE orders;
```

A full copy of orders for testing. No data is copied until a row changes.

## Why it matters

Testing on real data used to mean slow, costly copies. A clone makes a safe test copy cheap.

## Common mistake

Thinking a clone stays free. Every row you change in it writes new files, and those cost storage.

## Three principles

- **Shares files.** Nothing is copied at the start.
- **Writes on change.** New files only for changed rows.
- **Fast.** Ready in moments, even when huge.

## Related terms

- [Snowflake](https://learn.benibix.com/term/data/snowflake)
- [Delta Lake](https://learn.benibix.com/term/data/delta-lake)
- [Time Travel Query](https://learn.benibix.com/term/data/time-travel)
- [Separation of Storage and Compute](https://learn.benibix.com/term/data/separation-of-storage-and-compute)
- [Staging Table](https://learn.benibix.com/term/data/staging-table)
- [Object Storage](https://learn.benibix.com/term/data/object-storage)

![Two tables at the top, orders and its clone orders_test. Arrows from both point down at the same three stored files. The clone has one more arrow, to a dashed new file that holds only the rows changed in it. A note says the clone was made in moments, and its changes never reach the real table.](https://learn.benibix.com/diagrams/dat3-zero-copy-clone.svg)

---

Source: https://learn.benibix.com/term/data/zero-copy-clone
Author: Behnia Zarei (a developer in Vienna, Austria, who builds and teaches data, AI and business intelligence at BENIBIX)
Publisher: BENIBIX Learn (https://learn.benibix.com/)
Last updated: 2026-11-16
Licence: CC BY 4.0 (https://creativecommons.org/licenses/by/4.0/). Quote freely with attribution.
