When cloning a schema, which Snowflake object will not be included in the clone?
When cloning a schema, which Snowflake object will not be included in the clone?
Named internal stage will not be replicated/cloned to the new schema. External Stage can be cloned
A is correct https://docs.snowflake.com/en/sql-reference/sql/create-clone#:~:text=statement%20is%20executed.-,Not%20cloned,Internal%20(Snowflake)%20stages,-Pipes
My bad I wanted to type B
Named Internal Stages and External Tables, cannot be cloned. But, External Stages and Pipes for EXTERNAL STAGES, CAN BE CLONED.
Sorry. I selected wrongly: right answer is B.
When cloning a database or schema: External named stages that were present in the source when the cloning operation started are cloned. Tables are cloned, which means the internal stage associated with each table is also cloned. Any data files that were present in a table stage in the source database or schema are not copied to the clone (i.e. the cloned table stages are empty). Internal named stages are not cloned. reference : snowflake documentation
only named internal stage cannot be cloned