SHOW TBLPROPERTIES
Displays the table properties that are set for an Apache Iceberg table.
See Properties of Apache Iceberg Tables for a list of the supported properties.
Syntax
SHOW TBLPROPERTIES <table_name>
Parameter
<table_name> String
The path and name of the Iceberg table with the properties that you want to display.
Output
The output displays a table composed of these columns:
| Column | Data Type | Description |
|---|---|---|
| table_property_name | CHARACTER VARYING | The name of the property |
| table_property_value | CHARACTER VARYING | The value of the property |
| table_property_source | CHARACTER VARYING | The source of the value: TABLE for a value set directly on the table, or SYSTEM for a value that Dremio applies from a system option because the table does not set the property. Dremio only returns SYSTEM rows for properties whose system-derived value differs from the Iceberg default. |