The HELP DATABASE statement can be used to list the tables in a datalake database. The datalake and database name must be specified in the <datalake_name>.<database_name> format.
Columns Returned
- TableName
- TableProperties
Syntax
HELP DATABASE <datalake_name>.<database_name>;
Example: Iceberg
HELP DATABASE datalake_iceberg_glue.testdb; *** Query completed. 4 rows found. 2 columns returned. *** Total elapsed time was 1 second. TableName TableProperties ------------------------- ------------------------- test1 'teradata.purge.all'='true','write.object- storage.enabled'='true','write.parquet.compression-codec'='zstd' table1 'write.object- storage.enabled'='true','teradata'='creator','write.parquet.compression-codec'='GZIP' table2 'write.format.default'='parquet','write.object-storage.enabled'='true' table3 'write.merge.mode'='merge-on- read','teradata.purge.all'='true','write.object-storage.enabled'='true'
Example: Delta Lake
HELP DATALAKE datalake_deltalake_test.testdb; *** Query completed. 3 rows found. 2 columns returned. *** Total elapsed time was 1 second. DatabaseName DatabaseProperties ------------------------- ------------------------- default ? tmptbl 'delta.lastCommitTimestamp'='1727320427000','delta.lastUpdateVersion'='7','delta.minWriterVersion'='7','delta.u niversalFormat.enabledFormats'='iceberg','delta.enableIcebergCompatV1'='true','delta.enableDeletionVectors'='fa lse','delta.minReaderVersion'='3','delta.feature.icebergCompatV1'='supported','delta.columnMapping.mode'='name','delta.columnMapping.maxColumnId'='14','delta.feature.columnMapping'='supported' tab1 'delta.lastCommitTimestamp'='1710773118000','delta.lastUpdateVersion'='0','delta.minWriterVersion'='2','delta.e nableDeletionVectors'='false','delta.minReaderVersion'='1'
Usage Considerations
Default database property is '?'.