CREATE DATALAKE Syntax Elements - 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
TD_SERVER_DB
[Optional] Name of database on which to create the DATALAKE object.
datalake_name
Name for the DATALAKE object. Must be unique in TD_SERVER_DB and follow the rules in Object Names.
catalog_auth
Authorization for the catalog to associate with the DATALAKE object.
auth_type is the authorization type in the CREATE AUTHORIZATION statement used to create catalog_auth_name.
storage_auth
Authorization for the storage to associate with the DATALAKE object.
auth_type is the authorization type in the CREATE AUTHORIZATION statement used to create storage_auth_name.
You must specify catalog_auth and storage_auth even if the catalog and storage use the same authorization.
INVOKER
[Default] Only the current user can use the authorization object. The authorization object is created in the database of the current user.
DEFINER
Specify DEFINER to share the authorization object with multiple users of TD_SERVER_DB.
TRUSTED
Creates the authorization object as TRUSTED.
CATALOG_TYPE
Value Required Clauses
HIVE
  • CATALOG_LOCATION ('catalog_uri')
  • STORAGE_LOCATION (storage_uri)
  • STORAGE_REGION ('storage_region')
GLUE STORAGE_REGION ('storage_region')
UNITY
  • CATALOG_LOCATION ('catalog_uri')
  • UNITY_CATALOG_NAME ('unity_catalog_name')
  • STORAGE_ACCOUNT_NAME ('storage_account_name')
  • TENANT_ID ('tenant_id')
catalog_auth_name
Name of the catalog authorization object, created with the CREATE AUTHORIZATION statement.
storage_auth_name
Name of the storage authorization object, created with the CREATE AUTHORIZATION statement.
catalog_uri
URI of the catalog. For example:
thrift://example.com
storage_uri
URI of the storage. For example:
s3://example-iceberg-v1/
storage_region
Cloud region. For example:
us-west-2
unity_catalog_name
Unity/Azure Databricks catalog name. For example:
reg_iceberg_db
storage_account_name
Azure DataLake Storage Gen2 storage account name. For example:
reg_iceberg_db
tenant_id
Azure Active Directory service principal tenant ID. For example:
391c8c4c-6a2a-40fd-ab98-226b6baa5155
custom_clause
Options or credentials specific to this DATALAKE object.
Do not specify the same name-value pair more than once.
name
Option or credential.
value
Value of option or credential.
ICEBERG
Creates the DATALAKE object in Apache Iceberg Open Table Format.
Multiple DATALAKE objects can use the same catalog and storage. Typically, such objects have different name-value pairs in custom_clause.
Related information