PAUSE / RESUME MIRROR

It is easy to pause and resume mirroring between your Upsolver-managed Iceberg table and your Snowflake table by running the following commands from a Worksheet within your Upsolver account.

Syntax

// PAUSE THE MIRROR
PAUSE MIRROR <snowflake_connection_name.schema.tbl_name>;

// RESUME THE MIRROR
RESUME MIRROR <snowflake_connection_name.schema.tbl_name>;

Example

Pause a table mirror

You can pause a table mirror to temporarily stop replicating data to your Snowflake table:

// PAUSE THE MIRROR
PAUSE MIRROR my_snowflake_connection.mirror_demo_schema.mirror_iceberg_tbl;

Resume a table mirror

When you resume a table mirror, all data that was not mirrored during the time when it was paused, is then replicated to the mirrored table.

// RESUME THE MIRROR
RESUME MIRROR my_snowflake_connection.mirror_demo_schema.mirror_iceberg_tbl;