Examples for DATALAKE definition with Unity Catalog in ADLS Gen2 Storage - Teradata Vantage

Apache Iceberg and Delta Lake Open Table Format on VantageCloud Lake Getting Started

Deployment
VantageCloud
Edition
Lake
Product
Teradata Vantage
Published
December 2024
ft:locale
en-US
ft:lastEdition
2025-01-03
dita:mapPath
bsr1702324250454.ditamap
dita:ditavalPath
pny1626732985837.ditaval
dita:id
bsr1702324250454

Iceberg

CREATE DATALAKE unity_iceberg_wr 
EXTERNAL SECURITY INVOKER TRUSTED CATALOG auth_invoker_unity,
EXTERNAL SECURITY INVOKER TRUSTED STORAGE auth_invoker_unity
USING
catalog_type ('unity')
catalog_location ('https://adb-12345678910.6.azuredatabricks.net/api/2.1/unity-catalog/iceberg')
unity_catalog_name ('iceberg_db')
storage_account_name ('icebergstorageacct')
tenant_id ('391c8c4c-6a2a-40fd-ab98-111b0baa12345')
default_cluster_id ('0123-45678-ab0q59t3') 
TABLE FORMAT iceberg;

Delta Lake

CREATE DATALAKE unity_deltalake_wr 
EXTERNAL SECURITY INVOKER TRUSTED CATALOG auth_invoker_unity,
EXTERNAL SECURITY INVOKER TRUSTED STORAGE auth_invoker_unity
USING
catalog_type ('unity')
catalog_location ('https://adb-12345678910.6.azuredatabricks.net/api/2.1/unity-catalog/iceberg')
unity_catalog_name ('deltalake_db')
storage_account_name ('deltalakestorageacct')
tenant_id ('391c8c4c-6a2a-40fd-ab98-111b0baa12345')
default_cluster_id ('0123-45678-ab0q59t3') 
TABLE FORMAT deltalake;

Usage Considerations

default_cluster_id is required when the catalog is UNITY.