skills.rest
Paldom
PaldomCOMMUNITY
Explore all skills by this author →
GitHub

databricks-unity-catalog

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

1|1|Updated Nov 9, 2025
Search Tags:#governance#data lineage#databricks#volumes#audit logs#unity catalog
One-click install
npx skills add https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter --skill databricks-unity-catalog-paldom
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: databricks-unity-catalog
Source: https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter/tree/main/.agents/skills/databricks-unity-catalog
Command: npx skills add https://github.com/Paldom/databricks-apps-streamlit-vibe-coding-starter --skill databricks-unity-catalog-paldom

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill includes scripts (resource) and references (resource) components.

What problem does it solve?

This Skill simplifies complex Unity Catalog operations, enabling users to easily audit access, track data lineage, monitor billing, and manage files within volumes, thereby enhancing data governance and operational efficiency.

Core Features & Use Cases

  • System Table Queries: Access and analyze audit logs, lineage information, billing data, compute metrics, job history, and query performance.
  • Volume Management: Perform file operations like uploading, downloading, listing, and creating directories within Unity Catalog Volumes.
  • Use Case: A data engineer needs to investigate who recently modified permissions on a critical table. They can use this Skill to query the system.access.audit table for relevant GRANT or REVOKE actions.

Quick Start

Use the databricks unity catalog skill to list all files in the volume located at /Volumes/main/default/my_volume/.

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 audit logs to find who modified table permissions?▼

Query Databricks Unity Catalog audit logs by accessing the system.access.audit table to filter for specific GRANT or REVOKE actions. This allows you to investigate exactly who recently modified permissions on critical tables.

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

Track data lineage in Databricks Unity Catalog by querying system table information specifically designed for lineage tracking. This provides comprehensive visibility into data origins, transformations, and dependencies across your analytics environment.

How do I manage files in Databricks Unity Catalog volumes?▼

Manage files in Databricks Unity Catalog volumes by performing upload, download, list, and directory creation operations within the /Volumes/ namespace. You can execute these file management tasks using either Python SDK or SQL.

Can I analyze billing data and compute metrics using Databricks Unity Catalog system tables?▼

Yes, you can analyze billing data and compute metrics using Databricks Unity Catalog system tables. The system tables provide direct access to billing analysis data and compute metrics for monitoring operational efficiency and costs.

Does this Databricks Unity Catalog skill support both Python SDK and SQL for data governance tasks?▼

Yes, the Databricks Unity Catalog skill supports both Python SDK and SQL for executing data governance and operational tasks. This dual support allows you to interact with system tables and volumes using your preferred programming method.

What limitations exist when querying system tables for job history and query performance in Unity Catalog?▼

The skill facilitates querying system tables for job history and query performance, but constraints depend on the underlying Databricks system table retention policies. Users must ensure their workspace has the appropriate system schema enabled to access these operational metrics.

Related Skills

Explore More Data & Analytics Skills→
alessandro9110alessandro9110
4

databricks-unity-catalog

Query 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
ScottHMcKeanScottHMcKean

databricks-unity-catalog

Query Databricks Unity Catalog system tables and manage volume files.

Community
Intermediate
tja688tja688

unity-catalog-tagger

Apply and manage Unity Catalog metadata tags for tables, columns, and schemas.

Community
Advanced