CREATE DATALAKE Example: Delta Lake Format | Data Lakes | VantageCloud Lake - Example: Create DATALAKE object for Hive Catalog with storage_endpoint clause - Teradata Vantage

This example creates a DATALAKE object for Hive catalog with storage_endpoint clause.

CREATE DATALAKE iceberg_hive_endpoints
EXTERNAL SECURITY INVOKER TRUSTED CATALOG ICEBERG_INVOKER_SIMPLE ,
EXTERNAL SECURITY INVOKER TRUSTED STORAGE ICEBERG_INVOKER_SIMPLE 
USING 
catalog_type  ('hive')
catalog_location  ('thrift://example.com')
storage_location  ('s3://example-iceberg-v1/')
storage_region  ('us-west-2')
storage_endpoint('s3-fips.us-west-2.amazonaws.com')
TABLE FORMAT iceberg ;