databricks-unity-catalog

Query Unity Catalog system tables and volumes for governance and security analysis.

Updated Sep 9, 2017
One-click install
npx skills add https://github.com/mirakui/dotfiles --skill databricks-unity-catalog-mirakui
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-unity-catalog
Source: https://github.com/mirakui/dotfiles/tree/main/claude/skills/databricks-unity-catalog
Command: npx skills add https://github.com/mirakui/dotfiles --skill databricks-unity-catalog-mirakui

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Unity Catalog governance and data-management teams need a centralized, guided reference to query system tables and manage volumes, so they can monitor access, lineage, and costs without hunting for scattered docs.

Core Features & Use Cases

  • Guidance for querying Unity Catalog system tables (audit, lineage, billing) to monitor access events, data movement, and cost drivers.
  • Volume operations guidance for uploading, listing, and managing files under /Volumes/, along with governance considerations.
  • Real-world scenarios including permission auditing, lineage tracing, compute and storage cost analysis, and volume governance.

Quick Start

Query Unity Catalog system tables and volumes to gain governance visibility.

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 Databricks Unity Catalog system tables for access auditing?

Query Databricks Unity Catalog system tables for access auditing by running reference SQL queries against the audit tables to monitor access events and improve governance security across workspaces.

What is the best way to track data lineage in Databricks Unity Catalog?

Tracking data lineage in Databricks Unity Catalog is done by querying the lineage system tables to trace data movement and transformations across workspaces for governance visibility.

How do I manage files in Databricks Unity Catalog volumes?

Manage files in Databricks Unity Catalog volumes by using guided operations for uploading, listing, and managing files under the /Volumes/ directory with governance considerations applied.

Can I analyze compute and storage costs using Unity Catalog system tables?

You can analyze compute and storage costs using Unity Catalog system tables by querying the billing tables to identify cost drivers and perform governance-focused cost analysis.

Does Unity Catalog system table governance require any specific setup to query across workspaces?

Querying Unity Catalog system tables across workspaces for governance requires a Databricks environment configured for system tables to centralize access, lineage, and billing visibility.

What are the limitations when using system tables for Unity Catalog governance?

Limitations of using system tables for Unity Catalog governance include relying on available system table schemas for audit, lineage, and billing data, which may restrict custom governance queries.