What happens to pipes referencing internal stages during cloning?

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

Multiple Choice

What happens to pipes referencing internal stages during cloning?

Explanation:
Zero-copy cloning copies the metadata of objects, not the underlying storage objects. A pipe stores a reference to an internal stage, and that stage is a storage resource managed by Snowflake. When you clone, Snowflake does not duplicate internal stages, so the cloned pipe continues to reference the same internal stage rather than creating a new one. If you need the clone to use a separate stage, you’d have to create that stage in the clone and update the pipe to point to it.

Zero-copy cloning copies the metadata of objects, not the underlying storage objects. A pipe stores a reference to an internal stage, and that stage is a storage resource managed by Snowflake. When you clone, Snowflake does not duplicate internal stages, so the cloned pipe continues to reference the same internal stage rather than creating a new one. If you need the clone to use a separate stage, you’d have to create that stage in the clone and update the pipe to point to it.

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy