SHOW TBLPROPERTIES

Returns the value of a table property given an optional value for a property key. If no key is specified then all the properties are returned.

Note

This operation is an Iceberg-only operation.

Syntax

SHOW ( TBLPROPERTIES | PROPERTIES | TAGS ) <table_identifier> [ ('property_key') ] 

Examples

SHOW TBLPROPERTIES my_table;

  +---------------------+----------+
  |key                  |value     |
  +---------------------+----------+
  |property_1           |value_1   |
  |property_2           |value_2   |
  |property_3           |value_3   |
  +---------------------+----------+

SHOW TBLPROPERTIES my_table ('property_1');

  +----------+
  |value     |
  +----------+
  |value_1   |
  +----------+