databricks-unity-catalog

What problem does it solve?

This Skill helps data teams govern Unity Catalog data by guiding queries of system tables (audit, lineage, billing) and performing volume file operations (upload, download, list files in /Volumes/). It consolidates best practices and ready-to-use examples to accelerate governance, auditing, and catalog administration.

Core Features & Use Cases

• System Tables Guidance: Learn how to query Unity Catalog system tables for audit trails, lineage, and cost analytics.
• Volume Operations Guidance: Use /Volumes paths to read and manage volume data, including uploading and listing files.
• Use Case: You administer a Databricks workspace and need to audit user activity, trace data lineage, and monitor DBU usage across catalogs and schemas.

Quick Start

• Query audit logs: SELECT event_time, user_identity.email, action_name FROM system.access.audit WHERE event_date >= current_date() - 7 LIMIT 20;
• Inspect lineage: SELECT source_table_full_name, target_table_full_name, event_time FROM system.access.table_lineage ORDER BY event_time DESC LIMIT 20;
• Read files from a volume: SELECT * FROM read_files('/Volumes/main/default/my_volume/') LIMIT 50;