topic Automate Unity Access management Process at Schema, Tables, Cluster and Job in Data Engineering

Automate Unity Access management Process at Schema, Tables, Cluster and Job

ameet9257 — Wed, 04 Feb 2026 15:52:55 GMT

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

Re: Automate Unity Access management Process at Schema, Tables, Cluster and Job

anshu_roy — Fri, 13 Feb 2026 10:40:43 GMT

Hello Amit,

You can automate Unity Catalog permissions management using the Databricks Terraform provider instead of ad‑hoc scripts. With the databricks_grants resource you can declaratively manage privileges at the catalog, schema, table, and table/view levels for users and groups, and keep everything under version control: https://registry.terraform.io/providers/databricks/databricks/latest/docs/resources/grants .
For end‑to‑end examples of managing Databricks and Unity Catalog with Terraform (including CI/CD), have a look at the official examples repo: https://github.com/databricks/terraform-databricks-examples.

Hope this helps.

Re: Automate Unity Access management Process at Schema, Tables, Cluster and Job

saurabh18cs — Fri, 13 Feb 2026 11:09:52 GMT

Hi @ameet9257 see if this psot can help you : https://www.linkedin.com/posts/ishashankshekhar_databricks-unitycatalog-datagovernance-activity-7334515730937229312-yVPg?utm_source=share&utm_medium=member_desktop&rcm=ACoAAAlFpRcB2e5Ub33KKrsPHNgFLuA5WVkjuU4