Say this first: CLONE — shallow for a cheap short-lived snapshot, deep when the copy has to survive VACUUM and a possible DROP on the source.
Remember these
- Shallow clone references the source's files and dies when VACUUM removes them
- Deep clone copies files and survives source retention and DROP
- CLONE accepts VERSION AS OF or TIMESTAMP AS OF to pin the snapshot
- Deep clone can be re-run incrementally for recurring archives
Why: A shallow clone copies only metadata and points at the source table's existing data files, so it is near-instant and costs almost no storage — and it stops working the moment VACUUM on the source removes files the clone still references. A deep clone copies the data files into its own table and location, so it is independent of the source's retention, its VACUUM schedule, and a DROP. That independence is exactly what a one-year legal hold requires, which is why this is the moment to say out loud that time travel is not a backup. You can pin the snapshot precisely with VERSION AS OF or TIMESTAMP AS OF in the clone statement, and a deep clone can be re-run incrementally, copying only what changed, which makes it usable as a recurring archive rather than a one-off. The price is a second copy of the data and a lifecycle of its own.
CREATE TABLE finance.archive.orders_2026q3
DEEP CLONE finance.gold.orders VERSION AS OF 940;
Senior depth: The distinction I insist on is retention versus durability. Time travel and shallow clones are retention features inside one table's storage, governed by VACUUM, and they vanish with the table. Deep clones, cross-account copies, and storage replication are durability, because they survive the failure modes that take the original with it. Legal holds and audit requirements are durability questions, so they get deep clones in a separate location with their own lifecycle policy, and I write the recovery horizon down rather than inferring it from a table property.
Common mistake: Taking a shallow clone for an archive and losing it the first time the source is vacuumed.
Follow-up they will ask: What is a shallow clone genuinely good for, then?