DROP MIRROR

To drop mirroring between two tables, execute the following statement from a Worksheet in your Upsolver account.

Syntax

DROP MIRROR <snowflake_connection_name.schema.tbl_name>
    DROP_FROM_SNOWFLAKE = TRUE | FALSE;

Jump to:

• Table identifier

• DROP_FROM_SNOWFLAKE

Table identifier

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>

DROP_FROM_SNOWFLAKE

Us the DROP_FROM_SNOWFLAKE option to determine if the table should also be dropped from your Snowflake database.

---

Examples

// DROP THE MIRROR TABLE BUT LEAVE IN SNOWFLAKE
DROP MIRROR my_snowflake_connection.mirror_demo_schema.mirror_iceberg_tbl 
    DROP_FROM_SNOWFLAKE = FALSE;
    
// DROP THE MIRROR TABLE AND REMOVE FROM SNOWFLAKE
DROP MIRROR my_snowflake_connection.mirror_demo_schema.mirror_iceberg_tbl 
    DROP_FROM_SNOWFLAKE = TRUE;