Unity Catalog system tables and volumes. Use when querying system tables (audit, lineage, billing) or working with volume file operations (upload, download, list files in /Volumes/).
npx claudepluginhub leary-poken/ai-dev-kit --plugin databricks-ai-dev-kitThis skill uses the workspace's default tool permissions.
Guidance for Unity Catalog system tables, volumes, and governance.
Provides Ktor server patterns for routing DSL, plugins (auth, CORS, serialization), Koin DI, WebSockets, services, and testApplication testing.
Conducts multi-source web research with firecrawl and exa MCPs: searches, scrapes pages, synthesizes cited reports. For deep dives, competitive analysis, tech evaluations, or due diligence.
Provides demand forecasting, safety stock optimization, replenishment planning, and promotional lift estimation for multi-location retailers managing 300-800 SKUs.
Guidance for Unity Catalog system tables, volumes, and governance.
Use this skill when:
/Volumes/)| Topic | File | Description |
|---|---|---|
| System Tables | 5-system-tables.md | Lineage, audit, billing, compute, jobs, query history |
| Volumes | 6-volumes.md | Volume file operations, permissions, best practices |
| Data Profiling | 7-data-profiling.md | Data profiling, drift detection, profile metrics |
# List files in a volume
list_volume_files(volume_path="/Volumes/catalog/schema/volume/folder/")
# Upload file to volume
upload_to_volume(
local_path="/tmp/data.csv",
volume_path="/Volumes/catalog/schema/volume/data.csv"
)
# Download file from volume
download_from_volume(
volume_path="/Volumes/catalog/schema/volume/data.csv",
local_path="/tmp/downloaded.csv"
)
# Create directory
create_volume_directory(volume_path="/Volumes/catalog/schema/volume/new_folder")
-- Grant access to system tables
GRANT USE CATALOG ON CATALOG system TO `data_engineers`;
GRANT USE SCHEMA ON SCHEMA system.access TO `data_engineers`;
GRANT SELECT ON SCHEMA system.access TO `data_engineers`;
-- Table lineage: What tables feed into this table?
SELECT source_table_full_name, source_column_name
FROM system.access.table_lineage
WHERE target_table_full_name = 'catalog.schema.table'
AND event_date >= current_date() - 7;
-- Audit: Recent permission changes
SELECT event_time, user_identity.email, action_name, request_params
FROM system.access.audit
WHERE action_name LIKE '%GRANT%' OR action_name LIKE '%REVOKE%'
ORDER BY event_time DESC
LIMIT 100;
-- Billing: DBU usage by workspace
SELECT workspace_id, sku_name, SUM(usage_quantity) AS total_dbus
FROM system.billing.usage
WHERE usage_date >= current_date() - 30
GROUP BY workspace_id, sku_name;
Use mcp__databricks__execute_sql for system table queries:
# Query lineage
mcp__databricks__execute_sql(
sql_query="""
SELECT source_table_full_name, target_table_full_name
FROM system.access.table_lineage
WHERE event_date >= current_date() - 7
""",
catalog="system"
)