SQL Warehouse and Unity Catalog

[Senga98]

Hello,

Is SQL warehouses managed by Unity Catalog? My understanding is that since SQL Warehouse is part of the compute layer, Unity Catalog doesn't manage it as it only manages data layers.

[szymon_dybczak · Accepted solution]

Hi @Senga98 ,

Your understanding is correct. Unity Catalog governs:

• Data objects (catalogs, schemas, tables, views, functions)

• Permissions (grants on the above)

• Lineage

• Governed storage locations & external locations

• Model serving endpoints (UC Volumes / AI models)

SQL Warehouses, Clusters, Jobs compute fall under Databricks workspace compute, not UC.

But keep in mind that Unity Catalog governs data access permissions on SQL warehouses for most assets. Administrators configure most data access permissions. SQL warehouses can have custom data access configured instead of or in addition to Unity Catalog.