HELP DATALAKE - 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 DATALAKE statement queries the Iceberg or Delta Lake catalog and lists the databases present in the catalog.

Columns Returned

  • DatabaseName
  • DatabaseProperties

Syntax

HELP DATALAKE [TD_SERVER_DB.]<datalake_name>;

Example: Iceberg

HELP DATALAKE datalake_iceberg_test;
 *** Query completed. 4 rows found. 2 columns returned.
 *** Total elapsed time was 1 second.
DatabaseName                        DatabaseProperties
-------------------------           -------------------------
default                             ?

glue_db1                            'location'='s3://iceberg-v1/data','comment'='db test 1'

accdb                               'create_date'='2023-10-20','department'='Accounting'

otftestdb                           'owner'='tempuser','create_date'='2024-06-17'

Example: Delta Lake

HELP DATALAKE datalake_deltalake_test;
 *** Query completed. 3 rows found. 2 columns returned.
 *** Total elapsed time was 1 second.
DatabaseName                        DatabaseProperties
-------------------------           -------------------------
default                             ?
glue_db1                            'create_date'='2024-05-29', 'owner'='dbuser'
accdb                               'create_date'='2023-10-20','prop1'='value1'

Usage Considerations

Default database property is '?'.