Understand the table before asking it questions
Send Notis a candidate table name and get the schema details needed to plan a useful prospect analysis.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Get Table Schema
Gets the schema and column details for a table.
Why this helps
Writing a query against an unfamiliar schema can mean repeated guesswork about column names, types and keys.
- See the candidate table's columns and types before planning a query.
- Reduce trial and error when exploring prospect data.
- Get a concise schema report with the automation run.
Setup
Build it in a few focused steps.
- 1Connect Aeroleads and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a clear name.
- 3Tell Notis to use the candidate ClickHouse table name in the request to retrieve its schema and explain how its columns might support prospect analysis.
- 4Choose the notis_webhook trigger and select where run reports should go.
- 5Test with one real table name and confirm the schema report is accurate.
Questions about this workflow
Where does the table name come from?
Include the candidate table name in the HTTP request that starts the Notis webhook, or specify a fixed known table in the prompt.
Does this action run a prospect query?
No. Get Table Schema returns structural details for a specific table, including column definitions and types. Use Execute ClickHouse Query for SQL results.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Aeroleads to ClickHouse. A trigger fires from one place; an action lands in another.
Aeroleads 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.
Aeroleads 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.