Check effective Unity Catalog permissions from chat
Get a clearer view of access for a named Unity Catalog object without stopping to trace direct and inherited privileges yourself.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Get Effective Catalog Permissions
Tool to get effective permissions for a securable in Unity Catalog, including inherited permissions from parent securables. Use when you need to understand what privileges are granted to principals through direct assignments or inheritance. Returns privileges conveyed to each principal through the Unity Catalog hierarchy (metastore → catalog → schema → table/view/volume).
Why this helps
Working out who can access a data object can mean leaving a chat, opening Databricks, and checking privileges across inherited permissions.
- See effective permissions that include inherited access.
- Respond to access questions with a targeted lookup.
- Keep the run report with the request for later review.
Setup
Build it in a few focused steps.
- 1Connect 2chat and Databricks once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it for Unity Catalog access checks.
- 3Describe in one instruction how to retrieve effective permissions for the clearly identified securable in a request.
- 4Pick the Notis webhook trigger and choose where run reports should go.
- 5Test with one real request for an object you are permitted to inspect.
Questions about this workflow
How is this different from checking direct grants?
Effective permissions include privileges conveyed through direct assignments and inheritance. Direct grants alone exclude inherited permissions.
What should a request identify?
It should identify the Unity Catalog securable to inspect. The automation should send incomplete requests for clarification rather than assume an object.
Are permissions changed by this workflow?
No. This action retrieves effective permissions for review.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link 2chat to Databricks. A trigger fires from one place; an action lands in another.
2chat triggers
Databricks actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Add Member to Security Group
Tool to add a user or group as a member to a Databricks security group. Use when you need to grant group membership for access control.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete Custom LLM Agent
Tool to delete a Custom LLM agent created through Agent Bricks. Use when you need to remove a custom LLM and all associated data. This operation is irreversible and deletes all data including temporary transformations, model checkpoints, and internal metadata.
Create Databricks App
Tool to create a new Databricks app with specified configuration. Use when you need to create apps hosted on Databricks serverless platform to deploy secure data and AI applications. The app name must be unique within the workspace, contain only lowercase alphanumeric characters and hyphens, and cannot be changed after creation.
Delete Databricks App
Tool to delete a Databricks app from the workspace. Use when you need to remove an app and its associated service principal. When an app is deleted, Databricks automatically deletes the provisioned service principal.
Deploy Databricks App
Tool to create a deployment for a Databricks app. Use when you need to deploy an app with source code from a workspace path. The deployment process provisions compute resources and uploads the source code. Deployments can be in states: IN_PROGRESS, SUCCEEDED, FAILED, or CANCELLED.
Get Databricks App Details
Tool to retrieve details about a specific Databricks app by name. Use when you need to get comprehensive information about an app including configuration, deployment status, compute resources, and metadata.
Get Databricks App Permission Levels
Tool to retrieve available permission levels for a Databricks app. Use when you need to understand what permission levels can be assigned to users or groups for a specific app. Returns permission levels like CAN_USE and CAN_MANAGE with their descriptions.
Get Databricks App Permissions
Tool to retrieve permissions for a Databricks app. Use when you need to check who has access to an app and their permission levels. Returns the access control list including inherited permissions from parent or root objects.
Connect any two apps with Notis in the middle.
2chat and Databricks, or any other combination from 1,000+ integrations.
When this happens · Trigger
Do this · Action
Save your first hour today.
7-day trial of any paid plan, with 20$ of usage included.
No card. Works with personal or business Databricks.