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