Export Iceberg Tables DDL via dremio

1

I have a number of Iceberg tables in Minio.

Those tables are successfully read by Dremio.

However, I cannot find a way to export the DDL of those Iceberg tables via dremio.

Essentially, I am trying to get the metadata about the iceberg tables read by Dremio. (e.g. column, data types etc. etc.)

Is this possible?

2

Sorry.

I just found it in the INFORMATION.SCHEMA.COLUMNS

Thank you!

3

Hi @Ken Glad you found the answer,

If you want to see View definitions, you can query INFORMATION_SCHEMA.VIEWS

1 Like