How to know if a table is partitioned?

1

Hi,

I have an iceberg table created via dremio.

Now, after several months, I forgot what the partition columns are (or if the table is partitioned at all)

==========

I see that there’s the DESCRIBE TABLE command, but it is not showing the partition columns.

Is there currently a way to show the partition columns of a table?

It would help immensely analysing the tables (e.g. query performance).

2

@Ken

Try this query, only works for Iceberg tables

Query statistics related to the partitions of an Iceberg table.

TABLE( table_partitions( '<table_name>' ) )