Hi Team,

I’d like to automate the process of providing access to users and groups across:

• Schemas
• Tables
• Jobs
• Workflows
• Clusters

Currently, this is a manual, day-to-day process. Our goal is to implement an optimized, reliable solution.

Proposed approach (config + scripting):

• Use a config-file–based model (YAML/JSON) as the source of truth.
• A Python reconciler will read the configuration and update access in Unity Catalog and compute accordingly.
• Maintain the configuration in a Git repository to enable version control, change tracking, and reviews.

Request:

• Please share any prior experience with similar automation, including lessons learned, best practices, or recommended tooling.
• If feasible, let’s identify stakeholders and a suitable environment for a pilot.

#Unity #Access