CREATE MIRROR
Syntax
Jump to:
Table identifier
Table identifiers are provided in the following format:
Note that only metastore connection types are accepted for the catalog name.
Valid table names match the following identifier format:
IN
IN
This is the table identifier for your Snowflake table where your data will be mirrored. This should be in the following format:
CATALOG_INTEGRATION
CATALOG_INTEGRATION
The name of the catalog integration created in Snowflake.
EXTERNAL_VOLUME
EXTERNAL_VOLUME
The name of the external volume created in Snowflake.
MIRROR_INTERVAL
— editable
MIRROR_INTERVAL
— editableValue: 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
Last updated