Inspect the table behind a content report
Send the database and table names to Notis and get the table details you need before shaping a query.
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 or troubleshooting a report is harder when table columns and data types are out of sight.
- Retrieve details for one named table when needed.
- See column definitions and types in the run results.
- Use schema details to prepare a better query.
Setup
Build it in a few focused steps.
- 1Connect Agility CMS and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, or tell Notis in plain language from any channel.
- 3In one instruction, ask Notis to inspect the ClickHouse database and table names provided with the request, including sample data only if useful.
- 4Pick a webhook trigger and choose where run reports go.
- 5Test with one real example by sending the database and table names.
Questions about this workflow
Can I use the workflow before I know the table name?
This action needs a specific table. Use a database or table listing workflow first if you need to discover available names.
Does the inspection change any ClickHouse data?
No. It retrieves table schema information and optional sample data for inspection.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link Agility cms to ClickHouse. A trigger fires from one place; an action lands in another.
Agility cms 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.
Agility cms 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.