Mirrors

The mirrors system table includes information about Upsolver-managed Iceberg tables that are mirrored for access from Snowflake.

From a worksheet within Upsolver, run the following query:

SELECT * 
FROM system.information_schema.mirrors;

The system.information_schema.mirrors table includes the following columns:

Column	Type	Description
catalog	string	The connection name of the mirror table
created_at	datetime	The date and time when the mirror table was created.
created_by	string	The name of the user who created the mirror table.
id	string	The unique identifier for the mirror table.
name	string	The name of the mirror table.
original_table_name	string	The original (source) table being mirrored
original_table_catalog	string	The connection name of the original (source) table being mirrored
original_table_schema	string	The schema of the original (source) table being mirrored.
properties	string	A JSON field containing two properties: CATALOG_INTEGRATION - Snowflake catalog integration name. EXTARNAL_VOLUME - Snowflake external volume name.
status	string	Indicates whether the table is Running or Paused.