skills.rest
databricks-solutions
databricks-solutionsOFFICIAL
Explore all skills by this author →
GitHub

databricks-unity-catalog

Query Unity Catalog system tables and manage volumes under /Volumes.

1.8k|404|Updated Dec 17, 2025
Search Tags:#governance#audit-logs#databricks#unity-catalog#system-tables#volume-operations#table-lineage
One-click install
npx skills add https://github.com/databricks-solutions/ai-dev-kit --skill databricks-unity-catalog
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-unity-catalog
Source: https://github.com/databricks-solutions/ai-dev-kit/tree/main/databricks-skills/databricks-unity-catalog
Command: npx skills add https://github.com/databricks-solutions/ai-dev-kit --skill databricks-unity-catalog

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Unity Catalog governance and visibility require navigating both system tables and volume operations. This skill consolidates best practices for querying audit, lineage, billing, compute, and query history data, plus managing Unity Catalog volumes via the Volumes interface.

Core Features & Use Cases

  • System tables guidance: how to read audit logs, table lineage, and billing usage in system tables.
  • Volume operations: how to list, upload, download, and manage files in Unity Catalog volumes under /Volumes.
  • Governance and visibility: guidelines for governance, access control, and lineage tracking across catalogs and schemas.

Quick Start

Enable system table access and begin exploring volumes:

  • Grant necessary access: GRANT USE CATALOG ON CATALOG system TO data_team;
  • Query lineage example: SELECT source_table_full_name, target_table_full_name FROM system.access.table_lineage WHERE event_date >= current_date() - 7;
  • List volume contents: list volumes in catalog.schema using the Databricks SDK or UI.

Frequently Asked Questions about databricks-unity-catalog

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I query Unity Catalog system tables for audit logs and table lineage?▼

Query Unity Catalog system tables using standard SQL to read audit logs and table lineage. You can track governance and lineage by selecting source and target table names from system.access.table_lineage filtered by event date.

What is the best way to manage files in Databricks Unity Catalog volumes?▼

Manage Databricks Unity Catalog volumes by using the Databricks SDK or UI to list, upload, download, and manage files under the /Volumes directory. This allows direct file operations within catalog and schema boundaries.

Do I need external software to access Unity Catalog billing and compute history?▼

No external software is needed to access Unity Catalog billing and compute history. You can query these system tables directly using standard SQL, Python SDK snippets, and Databricks API calls.

How do I grant access to system tables for my data team in Databricks?▼

Grant access to system tables by executing a SQL command like GRANT USE CATALOG ON CATALOG system TO `data_team`. This enables your team to query governance, audit, and billing data.

Can I track data lineage across catalogs and schemas using Databricks system tables?▼

Yes, you can track data lineage across catalogs and schemas using Databricks system tables. Query the system.access.table_lineage table to retrieve source and target table full names for lineage visibility.

What limitations exist when querying system tables for Unity Catalog governance?▼

Querying system tables for Unity Catalog governance requires proper access grants. Ensure you have USE CATALOG permissions on the system catalog to successfully read audit logs, billing, and compute data.

Related Skills

Explore More Data & Analytics Skills→
thbehthbeh

databricks-unity-catalog

Query Unity Catalog system tables and manage volume file operations.

Community
Advanced
profmikegreeneprofmikegreene
1

early-anomaly-detection

Detect emerging anomalies and risk flags in live pilot metrics and data streams.

Community
Intermediate
PaldomPaldom
1

databricks-unity-catalog

Query Databricks Unity Catalog system tables and manage files in volumes.

Community
Intermediate
ThomazRossitoThomazRossito
31

databricks-unity-catalog

Query and govern Unity Catalog system tables and volumes.

Community
Intermediate