SnowPro Advanced Data Engineer

By Snowflake · Question Mode

QuestionQ113

Design and Manage Snowflake Resources and Performance

A Data Engineer is cloning a production database for use as a development environment with these commands:

USE ROLE CLONE_ADMIN;  
CREATE DATABASE DB_DEV CLONE DE_PROD AT (OFFSET => -1800);

What must the Engineer do to make sure the cloned environment is ready for use?

Explanation

When a database is cloned, cloned pipes are inactive by default: non-auto-ingest pipes are paused and auto-ingest pipes enter the STOPPED_CLONED state. Resuming each cloned pipe enables it to process applicable new file notifications and load data. Sequences cloned in the same database as their tables are already referenced by the cloned tables.

Learn more

Community Discussion

No comments yet. Be the first to start the discussion!