Can I clone a schema in Snowflake?

4.38K viewsCloning and Time TravelData Cloning
0

Can I clone a schema in Snowflake?

Frank Bell Answered question July 15, 2022
0

YES. Schemas are one of the Snowflake Objects that can be cloned. It is very easy to do. Its as simple as:\nCREATE SCHEMA SNOWFLAKE_SOLUTIONS_SCHEMA_CLONE FROM SNOWFLAKE_SOLUTIONS_SCHEMA;\nOther objects you can clone are: DATABASE, TABLE, STAGE, FILE FORMAT, SEQUENCE, STREAM, and TASK.

Frank Bell Answered question July 15, 2022