CREATE MIRROR

Syntax

CREATE MIRROR FOR <table_identifier>
    IN <snowflake_connection_name.schema.tbl_name>
    CATALOG_INTEGRATION = <CATALOG_INTEGRATION>
    EXTERNAL_VOLUME = <EXTERNAL_VOLUME>;

Jump to:

Table identifier

Table identifiers are provided in the following format:

<catalog_name>.<schema_name>.<table_name>

Note that only metastore connection types are accepted for the catalog name.

Valid table names match the following identifier format:

identifier = "([^"]|"")*"|[A-Za-z_][A-Za-z0-9_]*;

IN

This is the table identifier for your Snowflake table where your data will be mirrored. This should be in the following format:

<snowflake_connection_name>.<schema_name>.<table_name>

CATALOG_INTEGRATION

The name of the catalog integration created in Snowflake.

EXTERNAL_VOLUME

The name of the external volume created in Snowflake.


Example

CREATE MIRROR FOR default_glue_catalog.demo.my_iceberg_table
    IN my_snowflake_connection.mirror_demo_schema.mirror_iceberg_tbl
    CATALOG_INTEGRATION = my_catalog_int
    EXTERNAL_VOLUME = iceberg_volume; 

Last updated