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.

This component currently supports cloning schemas only.

Note

This component is only available in Tests.

Properties🔗

Snowflake

Name = string

A human-readable name for the component.

Clone object type = drop-down

The type of Snowflake object to clone. Currently only "Schema" is supported.

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.

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 for the new cloned schema.

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 name property 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
✅	❌	❌