Understand a ClickHouse Ad Table Before You Query It
Check a table's actual columns and types before you build an analysis around assumptions about the data.
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
Guessing at column names or data types can turn a quick ad question into repeated query failures and rework.
- Confirm table structure before query work begins.
- See returned keys and sample data for context.
- Reduce avoidable SQL errors caused by schema assumptions.
Setup
Build it in a few focused steps.
- 1Connect Adyntel and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis the outcome in plain language from any channel.
- 3Ask Notis to inspect the requested ClickHouse table and summarize its columns, types, keys, and sample data when available.
- 4Pick the Notis webhook as the trigger and choose where run reports should go.
- 5Test with one real table request and confirm the schema details are useful.
Questions about this workflow
Can I name the table in the webhook request?
Yes, if your prompt uses the incoming request to identify the table. Make sure the request supplies enough information to locate it.
Is sample data always returned?
Sample data is optional in the action. The report should state when sample data is unavailable.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Adyntel to ClickHouse. A trigger fires from one place; an action lands in another.
Adyntel 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.
Adyntel 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.