Find the ClickHouse tables available for campaign reporting
When an external process sends an HTTP request, have Notis list the tables in a specified database and summarize what is available.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
List ClickHouse Tables
Lists tables in databases with basic details.
Why this helps
Finding the right ClickHouse table can interrupt campaign work, especially when the database contains many tables and their purpose is not obvious.
- Start table discovery from an HTTP request.
- Review table names and available metadata in one report.
- Reduce the time spent searching for a likely source table.
Setup
Build it in a few focused steps.
- 1Connect ActiveCampaign and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis from any channel.
- 3Ask Notis to list tables in a named ClickHouse database and summarize the returned inventory.
- 4Pick a webhook trigger and choose where run reports should go.
- 5Test with one real webhook request and a database you can access.
Questions about this workflow
Does the table list explain what every table means?
The action returns table information such as engine, size, and row count. Provide any business definitions you want Notis to use when interpreting it.
What starts the workflow?
An external service or custom backend starts it by sending an HTTP request to the Notis webhook. ActiveCampaign does not provide a trigger event here.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Active campaign to ClickHouse. A trigger fires from one place; an action lands in another.
Active campaign 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.
Active campaign 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.