Recent Lessons

Show all results for ""

Feature Overview

Ace your exams with our all-in-one platform for creating and sharing quizzes and tests.

Quizzes

Create quizzes and tests automatically from your content using AI.

Flashcards

Automatically turn your notes into digital flashcards.

Share, Export & Embed

Share with classmates or export to Excel and your learning management system.

Stats & Reporting

Auto-grading quizzes and tests with detailed stats and reports.

Mobile Apps

The smarter way to study – wherever you are.

Pricing

Search...

10 Questions

1 Views

Snowflake CLONE Command

Choose a study mode

Play Quiz

Study Flashcards

Spaced Repetition

Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the primary purpose of the CLONE command in the given context?

To delete the existing objects and recreate them

To move the existing objects to a different location

To modify the existing objects in the system

To create zero-copy clones of databases, schemas, and tables (correct)

What does the CLONE command support for databases and schemas using the IGNORE TABLES WITH INSUFFICIENT DATA RETENTION parameter?

Modifying the tables with insufficient data retention

Deleting all tables with insufficient data retention

Skipping tables that have been purged from Time Travel (correct)

Creating additional copies of tables with insufficient data retention

How is the value specified for the exact date and time to use for Time Travel?

Set using a predefined variable

Specified using a special keyword

Explicitly cast to a TIMESTAMP (correct)

Entered as a string

What does the parameter specifying the difference in seconds from the current time for Time Travel support?

An integer or arithmetic expression in the form -N Signup and view all the answers

What is the requirement for the query ID of a statement to be used as the reference point for Time Travel?

It must reference a query executed within the last 14 days Signup and view all the answers

What privilege(s) does your current role need to have on the source object to create a clone?

OWNERSHIP on the database role and the CREATE DATABASE ROLE privilege on the target database Signup and view all the answers

What happens if the time specified in the AT | BEFORE clause is beyond the data retention period for any child table in a database?

The cloning operation for the child table is skipped Signup and view all the answers

What happens to the load history of a cloned table in comparison to its source table?

The load history of the source table is not included in the cloned table Signup and view all the answers

What happens to Automatic Clustering when a new table is created using CREATE TABLE … CLONE syntax?

Automatic Clustering is suspended for the new table Signup and view all the answers

What must be done if a database role is already cloned to the target database when running the CREATE CLONE command?

Drop the database role from the target database and try the CLONE command again Signup and view all the answers

Study Notes

CLONE Command

Primary purpose of CLONE command is to create a copy of a database, schema, or table.

Clone Command with IGNORE TABLES WITH INSUFFICIENT DATA RETENTION

Supports cloning of databases and schemas, excluding tables with insufficient data retention.

Time Travel

Exact date and time for Time Travel is specified using the AT | BEFORE clause.
Parameter specifying the difference in seconds from the current time for Time Travel is supported.

Query ID Requirement

Query ID of a statement must be used as the reference point for Time Travel.

Privilege Requirement

Current role needs to have the relevant privilege on the source object to create a clone.

Data Retention Period

If the time specified in the AT | BEFORE clause is beyond the data retention period for any child table in a database, the command will not be executed.

Load History of Cloned Table

Load history of a cloned table is not affected, and it will be the same as its source table.

Automatic Clustering

When a new table is created using CREATE TABLE … CLONE syntax, Automatic Clustering is disabled.

Creating a Clone

If a database role is already cloned to the target database when running the CREATE CLONE command, the command will not overwrite the existing clone; instead, the existing clone will be preserved.

Studying That Suits You

Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

Description

Learn about the CLONE command in Snowflake, which is used for creating zero-copy clones of databases, schemas, and other schema objects. This command is useful for quickly duplicating various schema objects such as external stages, file formats, and sequences in Snowflake.