Internal documentation
This feature is currently for internal use only. This documentation page must only be shared within Matillion.
Zero Copy Clone🔗
Internal only
The Zero Copy Clone test component creates a clone of a specified Snowflake object using Snowflake's zero-copy cloning feature. A zero-copy clone creates an instant copy of a source object without duplicating the underlying data. Additional storage is only consumed if the cloned object is modified.
Note
This component is only available in Tests.
Properties🔗
Name = string
A human-readable name for the component.
Clone object type = drop-down
The type of Snowflake object to clone. Supports Schema and Table.
Source database = drop-down
The Snowflake database that contains the object to clone. The special value [Environment Default] uses the database defined in the environment. Read Database, Schema, and Share DDL to learn more.
Source schema = drop-down
The Snowflake schema to clone. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Source table = drop-down
The Snowflake table to clone.
Available when Clone object type is set to Table.
Target database = drop-down
The Snowflake database where the cloned object will be created. The special value [Environment Default] uses the database defined in the environment. Read Database, Schema, and Share DDL to learn more.
Target schema name = string
The name of the new cloned schema.
Available when Clone object type is set to Schema.
Target schema = drop-down
The Snowflake schema where the cloned object will be created. The special value [Environment Default] uses the schema defined in the environment. Read Database, Schema, and Share DDL to learn more.
Available when Clone object type is set to Table.
Target table name = string
The name for the new cloned table.
Available when Clone object type is set to Table.
Create Method = drop-down
Choose how to create a target object.
Select one of the following options:
- Create: This is the default option. It creates a new schema, and will cause an error if a schema with the same name already exists. Existing data will not be affected.
- Create If Not Exists: This option creates a new schema when a schema of the same name does not already exist. This option will not destroy existing data.
- Replace: If a schema with the name you specify in the
Target schema nameproperty already exists, the existing schema is replaced by a new schema when the pipeline finishes. Any data from the existing schema (to be replaced) will be lost.
| Snowflake | Databricks | Amazon Redshift |
|---|---|---|
| ✅ | ❌ | ❌ |