SHOW ICEBERG TABLES 命令：输出中的新列¶

Attention

This behavior change is in the 2024_08 bundle.

For the current status of the bundle, refer to Bundle History.

When this behavior change bundle is enabled, the output of the SHOW ICEBERG TABLES command includes the following new column:

Column name Data type Description

Column name	Data type	Description
`catalog_sync_name`	String	Denotes the name of the catalog integration for Snowflake Open Catalog that the Snowflake-managed Apache Iceberg™ table is configured to be synced to. 此配置通过以下之一指定： 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: 未为 Iceberg 表配置同步目标。 Iceberg 表并非由 Snowflake 管理。 The `catalog_sync_name` column is added as the last column of the output, immediately following `name_mapping`.

catalog_sync_name

String

Denotes the name of the catalog integration for Snowflake Open Catalog that the Snowflake-managed Apache Iceberg™ table is configured to be synced to.

此配置通过以下之一指定：

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:

未为 Iceberg 表配置同步目标。
Iceberg 表并非由 Snowflake 管理。

The catalog_sync_name column is added as the last column of the output, immediately following name_mapping.

参考：1745