Skip to content
Notis

Keep Databricks metadata aligned with Airtable schema changes

Airtable schemas shift as your business evolves. Let Notis update the Databricks external metadata you specify when tables, fields, or views change.

Trigger

Base Schema Changed

Triggers when tables, fields, or views change in an Airtable base.

Action

Update External Metadata

Tool to update an external metadata object in Unity Catalog. Use when you need to modify metadata about external systems registered within Unity Catalog. The user must have metastore admin status, own the object, or possess the MODIFY privilege. Note that changing ownership requires the MANAGE privilege, and callers cannot update both the owner and other metadata in a single request.

Why this helps

Schema changes can leave Databricks documentation out of date, making it harder to trust what a connected data source represents.

  • Reduce manual updates to external metadata after schema changes.
  • Keep data source documentation easier to trust.
  • Get a run report when Notis updates the metadata.

Setup

Build it in a few focused steps.

  • 1Connect Airtable and Databricks once in the Notis portal.
  • 2Create an automation in the portal or tell Notis from any channel.
  • 3In one instruction, name the Airtable base and Databricks external metadata object, and describe how the metadata should reflect schema changes.
  • 4Pick the Airtable Base Schema Changed trigger and choose where run reports should go.
  • 5Test with one real schema change.

Questions about this workflow

What does this automation update?

It updates the external metadata object in Unity Catalog that you identify in your instruction. Specify the object and what information should be changed.

Does Notis discover every Databricks object connected to the Airtable base?

The available action updates a specified external metadata object. Name the object in your instruction; do not assume Notis can infer a connection that has not been supplied.

What starts the automation?

The Airtable Base Schema Changed event, which covers changes to tables, fields, or views.

When this happens · Trigger

Do this · Action

Supported Triggers and Actions

Notis builds workflows that link Airtable to Databricks. A trigger fires from one place; an action lands in another.

Airtable triggers

Databricks actions

Recurring trigger

Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.

TriggerScheduled

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.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

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.

ActionInstant

Base Metadata Changed

Triggers when an existing Airtable base changes its name or permission level.

TriggerPolling

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.

ActionInstant

Base Schema Changed

Triggers when tables, fields, or views change in an Airtable base.

TriggerPolling

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.

ActionInstant

User Profile Changed

Triggers when the connected Airtable user's profile information changes.

TriggerPolling

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.

ActionInstant

View Created

Triggers when a new view is created in an Airtable base.

TriggerPolling

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.

ActionInstant

View Deleted

Triggers when a previously known Airtable view is deleted.

TriggerPolling

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.

ActionInstant

View Metadata Changed

Triggers when an Airtable view changes its name or type.

TriggerPolling

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.

ActionInstant

Connect any two apps with Notis in the middle.

Airtable 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.