How to Duplicate a Table in Snowflake
Last updated July 24, 2026 · By the SaturnSQL team
CREATE TABLE ... CLONE makes a zero-copy duplicate instantly without consuming extra storage until the copies diverge. Use CREATE TABLE AS SELECT instead when you want a physically independent copy.
Zero-copy clone (preferred)
CREATE TABLE orders_backup CLONE orders;Physical copy with CTAS
CREATE TABLE orders_copy AS SELECT * FROM orders;Structure only, no rows
CREATE TABLE orders_empty LIKE orders;Run this in SaturnSQL
SaturnSQL is a browser-based SQL editor for teams: shared query library, schema-aware autocomplete, and scheduled exports to Google Sheets and Slack.
Try it free