Clone databases that contain hybrid tables
Cloning works in combination with Time Travel, which by default creates implicit continuous backups. After setting a data retention period, you can clone a database at any point in its Time Travel history to restore the database to a…
CREATE … CLONE command: Cloning databases and schemas that contain hybrid tables
In general, CREATE DATABASE … CLONE and CREATE SCHEMA … CLONE commands silently skip hybrid tables if any exist in the specified database or schema. CREATE DATABASE … CLONE commands do clone hybrid tables if no Time Travel parameters…
When a database, schema, or a table is restored using time travel or cloned does the privileges granted on these objects will be retained or not?
Answer: When you restore a database, schema, or table using time travel or when you clone a database, schema, or table, the role's privileges are not retained. This is expected behavior. The following example illustrates the different…
Cloning of a database may time-out after a long time
CAUSE: One of the main reasons of this long time taken by the Clone command is when there are too many objects (such as the tables or the tables having too many columns) irrespective of how many schemas it has in the database.
Cloning: Alerts cloned when cloning databases or schemas
Previously: When you clone a database or schema, any alerts in that database or schema are not cloned. Currently: When you clone a database or schema, any alerts in that database or schema will be cloned. The cloned alerts are suspended.
Behavior for View DDL and cloning
ISSUE: Users often use cloning utilities provided by Snowflake in order to prepare QA or DEV environments.Instantaneous copies of PROD or other environments can be prepared using Snowflake's data cloning feature.
Task Parameters Preserved When Cloning Databases, Schemas, and Tables
Task Parameters Preserved When Cloning Databases, Schemas, and Tables Attention This behavior change is in the 2023_01 bundle.
Best Practices for Data Lifecycle Management Using Snowflake Cloning and Access Controls
In scenarios where clones are created for non - archival purposes, careful consideration of access controls and management of database object security is a critical step prior to allowing user access to the cloned objects.
How-To: Automating Your Snowflake Database Cloning with GCP
Specifically, the notion that development is using stale, old or bad data to get their jobs done. Not only that, but traditionally developers have been hamstrung by having to share the same data for different purposes.
Database clone failed with error "Time travel data is not available"
CAUSE: This can be caused by some tables under the database or schema do not have valid time travel periods. This can be due to some tables having 0 days retention period setup, or the retention period has expired. SOLUTION: Add the…
Source