skills.rest
itsadijmbt
itsadijmbtCOMMUNITY
Explore all skills by this author →
GitHub

databricks-unity-catalog

Query Unity Catalog system tables for audit, lineage, billing, and compute history.

1|Updated Apr 24, 2026
Search Tags:#data lineage#data profiling#audit logs#unity catalog#system tables#volume file operations#billing analytics
One-click install
npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill databricks-unity-catalog-itsadijmbt
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-unity-catalog
Source: https://github.com/itsadijmbt/SecureMCP-Servers/tree/main/TEST_SERVERS/PORTED_TO_SECUREMCP/databrickslab-mcp/ai-dev-kit/databricks-skills/databricks-unity-catalog
Command: npx skills add https://github.com/itsadijmbt/SecureMCP-Servers --skill databricks-unity-catalog-itsadijmbt

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes references (resource) components.

What problem does it solve?

It helps you investigate and manage Unity Catalog governance by turning system-table insights, lineage, billing/compute/job history, and volume-based file operations into actionable queries and workflows.

Core Features & Use Cases

  • Unity Catalog system tables for audit, lineage, and operations: Query read-only system schemas like system.access (audit, table/column lineage), system.billing (usage and list prices), system.compute (clusters and warehouse events), system.lakeflow (job/pipeline history), system.query (query performance), and system.information_schema (object metadata).
  • Volume file operations in /Volumes/: Organize, upload, download, list, and manage data stored in Unity Catalog volumes, including understanding required privileges and common troubleshooting steps.
  • Data profiling/monitoring guidance: Set up data profiling monitors and understand where profile and drift metric tables land for snapshot and monitoring workflows.

Quick Start

Ask the skill to summarize what happened by querying recent permission changes and failed access attempts from system.access.audit for the last 7 days.

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 audit logs for failed access attempts?▼

Track Unity Catalog billing and compute costs by querying system.billing usage and list prices alongside system.compute cluster and warehouse events. Applying date-partition filtering to these system tables yields actionable cost and capacity trending analytics.

How do I manage volume file operations under /Volumes/ in Unity Catalog?▼

Investigate data lineage dependencies in Unity Catalog by querying system.access lineage for table and column relationships. This identifies downstream impacts and maps object metadata across system.information_schema for dependency tracking.

Do I need special grants to read Unity Catalog system tables?▼

Yes, reading Unity Catalog system tables requires appropriate grants for system schemas and tables within a Unity Catalog-enabled workspace. You must also apply date-partition filtering when querying these system tables for audit, lineage, or operational troubleshooting.

What is the best way to monitor query performance history in Unity Catalog?▼

Monitor query performance history in Unity Catalog by querying the system.query table. Analyzing this read-only schema alongside system.lakeflow job and pipeline history provides comprehensive operational troubleshooting for compute workloads.

Related Skills

Explore More Data & Analytics Skills→
leary-pokenleary-poken
1

databricks-unity-catalog

Query Unity Catalog system tables, volumes, and lineage for governance.

Community
Advanced
ice-droid-99ice-droid-99

databricks-unity-catalog

Query Unity Catalog system tables and manage /Volumes/ files with date-partition filters.

Community
Intermediate
marmikcfcmarmikcfc

metric-watcher

Compare committed metrics to current values and flag drift.

Community
Intermediate
juanlamadrid20juanlamadrid20

databricks-unity-catalog

Query Unity Catalog system tables for lineage, audit, and usage observability.

Community
Advanced