Keep track of Airtable views that were deleted
A deleted view can leave follow-up work behind. Log the event in ClickHouse so you can review any reports or processes that reference it.
Trigger
View Deleted
Triggers when a previously known Airtable view is deleted.
Action
Execute ClickHouse Query
Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.
Why this helps
Deleted views can go unnoticed by the people who rely on them for reporting or recurring work.
- Keep a record of deleted view events.
- Create a follow-up list for dependent reports and processes.
- Search past deletions when investigating a broken workflow.
Setup
Build it in a few focused steps.
- 1Connect Airtable and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3In one instruction, ask Notis to insert the deleted view name, available identifier, base context, and event time into a ClickHouse log table you specify.
- 4Pick the Airtable View Deleted trigger and choose where run reports go.
- 5Test with one real view deletion event.
Questions about this workflow
Will this find reports that use the deleted view?
The listed Airtable and ClickHouse events do not provide a dependency search. The workflow records the deletion so you can review dependencies separately or supply a supported query and dependency data.
What if the event does not include every detail?
The instruction can only record details available from the event. Check the test run and adjust the table columns to match.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtable to ClickHouse. A trigger fires from one place; an action lands in another.
Airtable triggers
ClickHouse actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute ClickHouse Query
Execute a sql query in clickhouse and return the results. this is the primary action for querying data from clickhouse databases.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Get comprehensive schema overview of an entire database including all tables and optionally their column definitions. essential for ai agents to understand the complete database structure in a single call.
Base Metadata Changed
Triggers when an existing Airtable base changes its name or permission level.
Get Table Schema
Get detailed schema information for a specific table including column definitions, types, keys, and optionally sample data. this is essential for ai agents to understand table structure before constructing queries.
Base Schema Changed
Triggers when tables, fields, or views change in an Airtable base.
List ClickHouse Databases
List all databases in the clickhouse instance. useful for discovering available databases before querying tables.
User Profile Changed
Triggers when the connected Airtable user's profile information changes.
List ClickHouse Tables
List tables in clickhouse databases. returns information about tables including their engine, size, and row count.
View Created
Triggers when a new view is created in an Airtable base.
View Deleted
Triggers when a previously known Airtable view is deleted.
View Metadata Changed
Triggers when an Airtable view changes its name or type.
Connect any two apps with Notis in the middle.
Airtable and ClickHouse, 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 ClickHouse.