Understand the ClickHouse data behind Airtop findings
When a browser workflow surfaces a question, get the database structure you need to decide where to look next.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Get Database Schema
Retrieves an overview of a database's schema and tables.
Why this helps
An extraction can prompt a useful analytics question, but unclear database structure makes it hard to know where an answer could come from.
- Retrieve a comprehensive overview of a ClickHouse database.
- Use schema context to plan a grounded follow-up query.
- Avoid guessing which tables may contain relevant data.
Setup
Build it in a few focused steps.
- 1Connect Airtop and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis in plain language from any channel.
- 3Describe which database schema to retrieve and how to relate it to the Airtop result in one instruction.
- 4Choose a webhook trigger and select where run reports should go.
- 5Test with one real Airtop result and confirm the schema report gives enough context for the next step.
Questions about this workflow
Does the Airtop result automatically identify the ClickHouse database?
Only if the result or your automation instruction supplies that information. Otherwise, specify the database context needed for the schema lookup.
Does this action include every column definition?
The database schema action provides an overview and can include column definitions. Request the detail needed for your use case.
Can this workflow run without an Airtop native event?
Yes. Airtop has no trigger events in this package, so a Notis webhook starts the workflow when it receives an HTTP request.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Airtop to ClickHouse. A trigger fires from one place; an action lands in another.
Airtop triggers
ClickHouse actions
Recurring trigger
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Execute ClickHouse Query
Runs a database query and returns the results.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Retrieves an overview of a database's schema and tables.
Get Table Schema
Gets the schema and column details for a table.
Get ClickHouse Play Interface
Returns the ClickHouse Play interface for writing queries and viewing results.
List ClickHouse Databases
Lists the databases in an instance.
List ClickHouse Tables
Lists tables in databases with basic details.
Connect any two apps with Notis in the middle.
Airtop 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.