In Snowflake which of the following objects can be cloned?

Question

In Snowflake Which of the following objects can be cloned? A. Tables B. Named File Formats C. Schemas D. Shares E. Databases F. Users

Tables, Schemas and Databases I know but can we also clone Users or Named File Format?

score 2 · Answer 1 · answered Oct 02 '21 at 00:23

2

You can directly clone DATABASE, SCHEMA, TABLE, STREAM, STAGE, FILE FORMAT, SEQUENCE, and TASK objects:

answered Oct 02 '21 at 00:23

Greg Pavlik

Hi Greg.. But how about Named File Format can it be cloned?? – Nicky Oct 02 '21 at 00:40
Also how about Users..Can it be cloned? – Nicky Oct 02 '21 at 00:41

score 1 · Accepted Answer · answered Oct 02 '21 at 10:07

1

In Snowflake, the following objects can be cloned:

Data Containment Objects
- Databases
- Schemas
- Tables
- Streams
Data Configuration and Transformation Objects
- Stages (external only - not internal)
- File Formats
- Sequences
- Tasks

The following account level objects cannot be cloned:

answered Oct 02 '21 at 10:07

Robert Long

Thanks Robert.. You are really gem ..You made my questions so simple to understand – Nicky Oct 02 '21 at 11:17
1

You're welcome. Happy that it helps ! – Robert Long Oct 02 '21 at 11:46

2 Answers2