ALTER DATALAKE Syntax | Data Lakes | VantageCloud Lake - ALTER DATALAKE Syntax - Teradata Vantage

Teradata® VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
January 2023
Language
English (United States)
Last Update
2024-04-03
dita:mapPath
phg1621910019905.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
phg1621910019905
ALTER DATALAKE [TD_SERVER_DB.]datalake_name
  [ catalog_auth [,...] ]
  [ storage_auth [,...] ]
  { ADD modify_clause [...] |
    DROP modify_clause [...]
  } [;]
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
modify_clause
{ CATALOG_TYPE ({ 'HIVE' | 'GLUE' | 'UNITY' }) |
  CATALOG_LOCATION ('catalog_uri') |
  STORAGE_LOCATION (storage_uri) |
  STORAGE_REGION ('storage_region') |
  UNITY_CATALOG_NAME ('unity_catalog_name') |
  STORAGE_ACCOUNT_NAME ('storage_account_name') |
  TENANT_ID ('tenant_id') |
  custom_clause [,...]
}
custom_clause
name ('value [,...]')