Governance

CH-UI Governance provides ClickHouse visibility similar to data governance platforms, but optimized for speed and operator workflows.

Modules

• Dashboard: inventory metrics and sync status
• Tables: metadata, comments, and notes
• Query Audit: query history and top query surfaces
• Lineage: edge and graph views
• Access: users, roles, access matrix, over-permissions
• Incidents: incident queue and comments
• Policies: policy definitions and violations

Sync Model

Governance sync workers cache ClickHouse metadata and access state in CH-UI SQLite.

Sync types:

• metadata
• query_log
• access

You can trigger full sync or single sync by type.

Access Operations

CH-UI can now manage ClickHouse users directly:

• Create user
• Delete user
• Change password

These operations exist in both Admin -> Users and governance access workflows.

Commenting And Notes

You can write:

• Table comments
• Column comments
• Table notes
• Column notes

This turns CH-UI into a light catalog for operational context.

Incident Flow

1. Policy violation appears.
2. Create incident from violation.
3. Assign severity/status.
4. Add threaded comments and resolve.