03- Unity Catalog Creating metastore in Azure Unity Catalog

03- Unity Catalog Creating metastore in Azure Unity Catalog

Creating a Unity Catalog Meta Store

Introduction to Unity Catalog

  • The video introduces the process of creating a Unity catalog meta store, referencing previous videos for foundational knowledge on Unity catalog and prerequisites.

Accessing Azure Portal

  • Users are instructed to log into the Azure portal where resources like Databricks workspace, ADL storage, and access connector for Azure Databricks have been created within a resource group.

Navigating the Unity Catalog Interface

  • Upon logging in, users will see the Unity catalog account page with options such as workspace menu and data tab. The workspace menu lists available workspaces in the tenant.
  • The data tab shows any existing metastore; since this is a new environment, no metastore has been created yet.

User Management Features

  • User management allows onboarding of users from Azure Active Directory (AAD), including service principals and groups. Settings enable user provisioning through AAD integration.

Creating a Meta Store

  • A meta store is defined as a repository for databases, tables, schemas, etc., utilizing ADLS storage in the backend.
  • To create a meta store, users must provide a name and select an appropriate location that matches other resources.

Configuring Storage Account Details

  • Users need to specify their container name within the ADLS Gen 2 path and obtain necessary details from the Azure portal settings endpoint.

Access Connector ID Requirement

  • An access connector ID is required during setup; it should have "Storage Blob Contributor" permissions on the specified storage account to avoid permission issues.

Assigning Workspaces to Meta Store

  • Users can assign their newly created meta store to one or more workspaces during creation or later.

Validating Meta Store Integration

  • After creating the meta store, validation can be done by launching the associated workspace where users can confirm that their meta store is attached.

Exploring Data Menu Options

  • In the data menu of Unity catalog, users can view details about their attached meta store including its path and associated workspaces.
Video description

This video will explain how to create metastore in Unity Catalog and assign to a databricks workspace. Unity Catalog Videos 01. Unity Catalog Introduction - https://www.youtube.com/watch?v=yc5BHW149hs&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=1 02. Unity Catalog Configuration prerequisites - https://www.youtube.com/watch?v=FQnb1-kbbig&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=2 03. Creating Metastore - https://www.youtube.com/watch?v=vAab07QrLZk&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=3 04. Create catalog schema and tables - https://www.youtube.com/watch?v=Z13OHMWs6zc&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=4 05. Lineage - https://www.youtube.com/watch?v=fFYL_h-6II4&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=5 06. Delta Sharing - https://www.youtube.com/watch?v=1TxsOosaQ0k&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=6 07. Create External Location - https://www.youtube.com/watch?v=h-RJn0cfSOo&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=7 08. SCIM Configuration - https://www.youtube.com/watch?v=oLS1soW_gD8&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=8 09. Create compute cluster - https://www.youtube.com/watch?v=dQ5mV9v5kDY&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=9 10. Admin Roles in Unity Catalog - https://www.youtube.com/watch?v=KBXr1VfQgAQ&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=10 11. Managed Tables in Unity Catalog - https://www.youtube.com/watch?v=ZYnKrox83Lw&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=11 12. Lakehouse Federation - https://www.youtube.com/watch?v=bVmIlOxVbu4&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=13 13. Row Level Access Control - https://www.youtube.com/watch?v=Gc0SX3mj3YE&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=14 14. Column Masking - https://www.youtube.com/watch?v=PU1OVz5OKfo&list=PLY-V_O-O7h4fwcHcXgkR_zTLvddvE_GfC&index=15 How to create metastore in Unity Catalog Assign metastore to databricks workspace Enable Unity Catalog in Azure Databricks Azure Databricks Unity Catalog Centralized metastore using Unity Catalog Create Metstore for Unity Catalog