If the source table has automatic clustering enabled, the new table created by CLONE starts with Automatic Clustering suspended.

Master the SnowPro Advanced Architect Test with flashcards, multiple-choice questions, and detailed explanations. Prepare thoroughly for your certification!

Multiple Choice

If the source table has automatic clustering enabled, the new table created by CLONE starts with Automatic Clustering suspended.

Explanation:
When you clone a table, Snowflake makes a zero-copy copy of the table metadata and data, and Automatic Clustering is a separate, background service tied to a table. If the source table has Automatic Clustering enabled, the new clone is created with that clustering feature suspended by default. This prevents the clone from immediately starting clustering work, giving you control over when clustering should run on the clone. If you want the clone to start clustering again, you explicitly resume it with an ALTER TABLE <clone> CLUSTERING RESUME command. The clone remains independent of the source, so you can keep it suspended or resume clustering on the clone as needed.

When you clone a table, Snowflake makes a zero-copy copy of the table metadata and data, and Automatic Clustering is a separate, background service tied to a table. If the source table has Automatic Clustering enabled, the new clone is created with that clustering feature suspended by default. This prevents the clone from immediately starting clustering work, giving you control over when clustering should run on the clone. If you want the clone to start clustering again, you explicitly resume it with an ALTER TABLE CLUSTERING RESUME command. The clone remains independent of the source, so you can keep it suspended or resume clustering on the clone as needed.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy