Discover ClickHouse tables for creative analytics
Get a readable schema overview when a creative analytics request arrives, so you can see what data is available before querying it.
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
Writing an analytics query is harder when the available tables and columns are unclear or spread across a large database.
- Retrieve a comprehensive schema overview for a named database.
- Summarize table and column details that help inform a later query.
- Call out when a database name or schema detail was not provided.
Setup
Build it in a few focused steps.
- 1Connect Abyssale and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, and give it a name.
- 3Tell Notis to use the database named in each request to retrieve its schema and summarize relevant tables and columns.
- 4Pick the webhook trigger and choose where run reports should go.
- 5Test with one real request that names a database and review the returned schema summary.
Questions about this workflow
What should the webhook request include?
Include the ClickHouse database name and the creative analytics question or context that will help Notis summarize relevant schema details.
Does a schema overview run the analytics query too?
No. This workflow retrieves schema information. Executing a SQL query is a separate ClickHouse action.
What if the database name is missing?
The workflow should report that it needs a database name rather than guessing which database to inspect.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Abyssale to ClickHouse. A trigger fires from one place; an action lands in another.
Abyssale 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.
Abyssale 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.