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.