I have some Athena databases which contain a number of tables, and I know some of these tables use the Iceberg format. It’s important to me to know which are Iceberg tables, because those will allow a greater range of INSERT, UPDATE, and ALTER queries that the basic EXTERNAL table type.
When we create Iceberg tables in Athena we set the table_type property like this:
<code>CREATE TABLE my_table
-- specify columns, partition, location, etc
TBLPROPERTIES ('table_type' ='ICEBERG')
</code>
<code>CREATE TABLE my_table
-- specify columns, partition, location, etc
TBLPROPERTIES ('table_type' ='ICEBERG')
</code>
CREATE TABLE my_table
-- specify columns, partition, location, etc
TBLPROPERTIES ('table_type' ='ICEBERG')
How can I check the value of this property from Athena when working with tables? If that’s not possible, what’s a suitable proxy for this so that I can determine whether a table is an Iceberg table (vs an External table)?