SHOW ICEBERG TABLES command: New columns in output (Preview)¶

partition_specs

List of objects containing the Apache Iceberg™ partition specs for the Iceberg table as they appear in the Iceberg metadata file. It returns the partition specs for both Snowflake-managed and externally managed Iceberg tables.

Each partition spec includes a spec-id, followed by the fields for the partition spec. Each field is an OBJECT value with the following key-value pairs:

• name: The name of the partition.

• transform: The transformation applied to the source column to generate a partition value. This value determines how data is grouped into partitions.

• source-id: The identifier of the original table column or field used for partitioning.

• field-id: The partition field id. This field is used to identify a partition field and is unique in a partition spec. However, for v2 table metadata, it’s unique across all partition specs.

For example:

[ {
"spec-id" : 0,
"fields" : [ {
"name" : "COL1",
"transform" : "identity",
"source-id" : 1,
"field-id" : 1000
}, {
"name" : "COL1_trunc_100",
"transform" : "truncate[100]",
"source-id" : 1,
"field-id" : 1001
},
// Additional fields omitted for brevity.
    ]
} ]

The example shows one partition spec; however, a table can have multiple partition specs.

This column appears after the auto_refresh_status column.