CREATE MIRROR

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

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; 

Last updated