CREATE MIRROR

Prior to creating a mirror on your table, please ensure you create a catalog integration and S3 volume in Snowflake, and create the table you want to mirror. See this guide for instructions.

Syntax

CREATE MIRROR FOR <table_identifier>
    IN <snowflake_connection_name.schema.tbl_name>
    CATALOG_INTEGRATION = <CATALOG_INTEGRATION>
    EXTERNAL_VOLUME = <EXTERNAL_VOLUME>
    MIRROR_INTERVAL = <integer> { MINUTE[S] | HOUR[S] | DAY[S] };

Jump to:

• Table identifier

• IN

• CATALOG_INTEGRATION

• EXTERNAL_VOLUME

• MIRROR_INTERVAL

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.

MIRROR_INTERVAL— editable

Value: integer {MINUTE[S] | HOUR[S] | DAY[S] }

Default: 1 MINUTE

(Optional) How often the Snowflake mirror table is updated.

Set this option to update your Snowflake table less frequently than your Iceberg table in order to control Snowflake costs.

---

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
    MIRROR_INTERVAL = 1 HOUR;