The Unity Catalog permission that allows work through a connection, such as creating a foreign catalog or building pipelines, while keeping its credentials hidden.
Read more: Databricks docs
In the Ultra Transcenders books
Each book explains USE CONNECTION in context, with comparison tables and the common traps.
Terms in this definition
- Unity Catalog
Azure Databricks' governance solution covering both data and AI in one place, with centralised permissions, auditing, data discovery and lineage.
- Connection
Resource that attaches a virtual network gateway to its peer, which may be an ExpressRoute circuit, a second VNet gateway (Vnet2Vnet) or a local network gateway over IPsec. Resetting it recovers a single tunnel and avoids rebooting the whole gateway.
- Foreign catalog
Mirrors a database living in another system so it can be queried read-only from Unity Catalog over a Lakehouse Federation connection. Making one takes
CREATE CATALOG, and on the connection you need ownership orCREATE FOREIGN CATALOG.