HELP DATABASE - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

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 '?'.