Review who can effectively access affiliate data
Create a recurring review of effective permissions for a chosen catalog, schema, table, or other supported securable.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
Get Effective Catalog Permissions
Retrieves effective permissions, including inherited access.
Why this helps
Reviewers can miss access granted through parent resources when they look only at direct assignments.
- Include privileges conveyed through inheritance.
- Make recurring access reviews easier to complete.
- Keep permission review results available in run reports.
Setup
Build it in a few focused steps.
- 1Connect Adtraction and Databricks once in the Notis portal.
- 2Create an automation in Automations, New Automation, with a name and prompt.
- 3Tell Notis to retrieve effective permissions for the named securable and summarize principals and privileges.
- 4Choose a recurring schedule and where run reports should go.
- 5Test with one real securable that you are authorized to review.
Questions about this workflow
How is this different from direct grants?
Effective permissions include privileges conveyed through direct assignments and inheritance from parent securables.
Does the workflow revoke access?
No. It retrieves permissions for review and does not modify them.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Adtraction to Databricks. A trigger fires from one place; an action lands in another.
Adtraction 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
Adds a user or group to a Databricks security group.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Delete Custom LLM Agent
Irreversibly deletes a custom LLM agent and all its associated data.
Create Databricks App
Creates a Databricks app in the workspace.
Delete Databricks App
Deletes a Databricks app and its associated service principal.
Deploy Databricks App
Deploys an app from workspace source code and provisions its compute resources.
Get Databricks App Details
Retrieves an app’s configuration, deployment status, resources, and metadata.
Get Databricks App Permission Levels
Lists the permission levels available for an app.
Get Databricks App Permissions
Retrieves who can access an app and their permission levels.
Connect any two apps with Notis in the middle.
Adtraction 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.