When cloning a database or schema, any pipes in the source container that reference an internal (Snowflake) stage are not cloned.

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

Multiple Choice

When cloning a database or schema, any pipes in the source container that reference an internal (Snowflake) stage are not cloned.

Explanation:
Zero-copy cloning only duplicates objects and metadata that stay self-contained within the cloned scope. Internal Snowflake stages are account- or database-scoped resources, not part of the data pages being cloned. Because a pipe references that internal stage, carrying over the pipe would create a broken reference in the clone. Snowflake therefore omits such pipes during the clone. If you need ingestion in the cloned environment, you’d recreate the pipe there and point it to a stage that exists in the clone (or to a suitable external stage).

Zero-copy cloning only duplicates objects and metadata that stay self-contained within the cloned scope. Internal Snowflake stages are account- or database-scoped resources, not part of the data pages being cloned. Because a pipe references that internal stage, carrying over the pipe would create a broken reference in the clone. Snowflake therefore omits such pipes during the clone. If you need ingestion in the cloned environment, you’d recreate the pipe there and point it to a stage that exists in the clone (or to a suitable external stage).

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy