CREATE/REPLACE DATALAKE Syntax | Data Lakes | VantageCloud Lake - CREATE DATALAKE and REPLACE DATALAKE Syntax - Teradata Vantage

{ CREATE | REPLACE } CREATE DATALAKE [TD_SERVER_DB.]datalake_name
  catalog_auth [,...]
  storage_auth [,...]
  USING
  CATALOG_TYPE ('UNITY')
  [ CATALOG_LOCATION ('catalog_uri') ]
  [ CATALOG_ENDPOINT ('catalog_url') ]
  [ STORAGE_LOCATION (storage_uri) ]
  [ STORAGE_ENDPOINT ('storage_url') ]
  [ STORAGE_REGION ('storage_region') ]
  [ UNITY_CATALOG_NAME ('unity_catalog_name') ]
  [ STORAGE_ACCOUNT_NAME ('storage_account_name') ]
  [ TENANT_ID ('tenant_id') ]
  [ custom_clause [,...] ]
  TABLE FORMAT { ICEBERG | DELTALAKE } [;]

catalog_auth

EXTERNAL SECURITY auth_type CATALOG catalog_auth_name

storage_auth

EXTERNAL SECURITY auth_type STORAGE storage_auth_name

auth_type

[ INVOKER | DEFINER ] TRUSTED

custom_clause

name ('value [,...]')