When a database or schema that contains tasks is cloned, the tasks in the clone are suspended by default?

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

Multiple Choice

When a database or schema that contains tasks is cloned, the tasks in the clone are suspended by default?

Explanation:
When Snowflake clones a database or schema, the objects inside are meant to be safe to work with in a new environment. For tasks, this means they don’t start running automatically in the clone. The cloned tasks are suspended by default, so you have to explicitly resume them if you want them to execute. This behavior helps prevent unintended ETL runs or compute usage in development or testing environments. To enable a task, you would issue a resume command for the specific task (and do so for any others you want to run).

When Snowflake clones a database or schema, the objects inside are meant to be safe to work with in a new environment. For tasks, this means they don’t start running automatically in the clone. The cloned tasks are suspended by default, so you have to explicitly resume them if you want them to execute. This behavior helps prevent unintended ETL runs or compute usage in development or testing environments. To enable a task, you would issue a resume command for the specific task (and do so for any others you want to run).

Subscribe

Get the latest from Passetra

You can unsubscribe at any time. Read our privacy policy