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;