databricks-unity-catalog

Query Unity Catalog system tables and manage volume files via Python SDK and SQL.

Updated Feb 27, 2026
One-click install
npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill databricks-unity-catalog-laurentprat-db
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: databricks-unity-catalog
Source: https://github.com/LaurentPRAT-DB/LPT_claude_config/tree/main/skills/databricks-unity-catalog
Command: npx skills add https://github.com/LaurentPRAT-DB/LPT_claude_config --skill databricks-unity-catalog-laurentprat-db

SYSTEM DOCUMENTATION & REQUIREMENTS

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

What problem does it solve?

This Skill simplifies complex data governance and file management tasks within Databricks Unity Catalog, enabling efficient querying of system metadata and seamless handling of unstructured data.

Core Features & Use Cases

  • System Table Querying: Access and analyze audit logs, lineage, billing, compute, job, and query history for deep operational insights.
  • Volume File Operations: Upload, download, list, and manage files within Unity Catalog volumes, supporting unstructured data needs for ML and data staging.
  • Use Case: A data engineer needs to track all access attempts to sensitive tables over the last week and also upload a set of images for an ML model training dataset into a Unity Catalog volume.

Quick Start

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

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 to analyze audit logs and lineage?

Querying Unity Catalog system tables allows you to access and analyze audit logs, lineage, billing, and query history. You can interact with this system metadata using either Python SDK or SQL interfaces to gain deep operational insights.

What is the best way to manage unstructured data files within Databricks volumes?

Managing unstructured data within Databricks volumes involves using volume file operations to upload, download, list, and manage files. This supports unstructured data needs for machine learning datasets and data staging within Unity Catalog.

Can I use Python SDK and SQL interfaces to interact with Unity Catalog metadata?

Yes, you can use both Python SDK and SQL interfaces to interact with Unity Catalog. These interfaces support querying system metadata for audit logs and lineage, alongside manipulating file storage within volumes.

How do I track access attempts to sensitive tables using Databricks system tables?

To track access attempts to sensitive tables, you can query the audit logs available within Unity Catalog system tables. This provides a comprehensive record of access history and operational events for data governance.

Does this approach support querying compute and job history alongside file operations?

Yes, querying system tables supports accessing compute, job, and billing history. This capability runs alongside volume file operations, allowing you to simultaneously manage unstructured data and analyze operational metadata.

When do I need Unity Catalog volumes for my data staging and ML workflows?

You need Unity Catalog volumes when your workflows require handling unstructured data, such as uploading images for ML model training datasets. Volumes provide a structured way to stage and manage these files directly within Databricks.