catalog_sync_name
|
String |
Denotes the name of the catalog integration for Polaris Catalog that the Snowflake-managed Apache Iceberg™ table is configured to be
synced to.
This configuration is specified through one of the following:
The CATALOG_SYNC parameter for the CREATE ICEBERG TABLE (Snowflake as the Iceberg catalog) command. The ALTER <object> command by using ALTER <domain> SET CATALOG_SYNC… syntax, where <domain> can
either be account, database, schema, or iceberg table. When setting <domain> on a non-table
domain, all tables under the domain will be propagated with the CATALOG_SYNC target, so their catalog_sync_name column from
SHOW ICEBERG TABLES will contain this value that was set from the higher domain.
If the CATALOG_SYNC parameter is set both on the table and a higher domain, the finer-grained domain (that is, the parameter on table)
will be respected and returned in the command output. For example, if the parameter is set on both schema and table, the parameter
value for the table is returned in the catalog_sync_name column for SHOW ICEBERG TABLES.
If one of the following is true, the value for catalog_sync_name is NULL:
The catalog_sync_name column is added as the last column of the output, immediately following name_mapping.
|