Following objects can be cloned in snowflake

Following objects can be cloned in snowflake

A. Permanent table

B. Transient table

C. Temporary table

D. External tables

E. Internal stages

View Answer

Answer: A,B,E

Explanation:

In Snowflake, the ability to clone objects is an important feature for quickly duplicating the schema and data of various database objects. Here’s the capability of cloning the listed objects:

A. Permanent table

Yes, permanent tables can be cloned in Snowflake. The clone includes the data and schema of the table at the time of cloning.

B. Transient table

Yes, transient tables can also be cloned. Similar to permanent tables, the clone includes the data and schema of the transient table.

C. Temporary table

No, temporary tables cannot be cloned in Snowflake. Temporary tables are session-specific and are dropped automatically when the session ends.

D. External tables

No, external tables cannot be directly cloned in Snowflake. External tables point to data stored outside of Snowflake, typically in an external stage, and their metadata can be replicated or recreated, but not cloned in the same way as internal tables.

E. Internal stages

Yes, internal stages can be cloned in Snowflake. Cloning an internal stage creates a new stage with the same file format and other settings.

Therefore, the objects that can be cloned in Snowflake are:

A. Permanent table

B. Transient table

E. Internal stages