SHOW DATALAKE Statement - 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 SHOW DATALAKE statement can be used to examine the contents of the DATALAKE object.

Syntax

SHOW DATALAKE <datalake_name>;

Example

SHOW DATALAKE datalake_test;
 *** Text of DDL statement returned.
 *** Total elapsed time was 1 second.
---------------------------------------------------------------------------
CREATE DATALAKE datalake_test
EXTERNAL SECURITY INVOKER TRUSTED CATALOG glue_s3_auth,
EXTERNAL SECURITY INVOKER TRUSTED STORAGE glue_s3_auth
USING
   catalog_type ('glue')
   storage_location ('s3://<folder>/')
   storage_region ('us-west-2')
TABLE FORMAT iceberg;