Locate ClickHouse tables for address event analysis
When an address event needs a closer look, have Notis list the tables in the database you specify.
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
Searching through unfamiliar tables can make an address delivery investigation feel like a separate project.
- List tables in the relevant database when an address event prompts investigation.
- Review table names and available inventory details in a report.
- Reduce manual discovery before deciding which data to query.
Setup
Build it in a few focused steps.
- 1Connect Addresszen and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name the table inventory workflow.
- 3Tell Notis to list tables in the specified ClickHouse database and summarize the results in the context of the incoming event.
- 4Choose a webhook trigger and configure an external sender to post address event context to it.
- 5Choose a report channel, then test with one real example that includes a valid database name.
Questions about this workflow
Does this workflow monitor Addresszen directly?
No. Addresszen has no listed trigger events. An external system starts the workflow by sending a request to the Notis webhook.
What does the table listing include?
It returns information about tables, including their engine, size, and row count where available.
Does it analyze address records?
No. It lists table information. Use a query action when you are ready to analyze records.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Addresszen to ClickHouse. A trigger fires from one place; an action lands in another.
Addresszen 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.
Addresszen 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.