Know what a weather table contains before querying
Request a focused explanation of a weather table's structure before building an analysis around it.
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 a query against an unfamiliar table can mean wasted time and avoidable errors.
- Retrieve details for one specified table when needed.
- Understand column types and keys before constructing a query.
- Get the schema summary in the configured run report channel.
Setup
Build it in a few focused steps.
- 1Connect AccuWeather and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, and name it for table inspection.
- 3Tell Notis to use the requested database and table to retrieve the table schema and summarize its columns, types, and keys.
- 4Pick the webhook trigger, choose where run reports go, and save the automation.
- 5Test with one real example by sending a request that names an existing weather table.
Questions about this workflow
Can the webhook choose the table?
Include the database and table name in the request or specify a fixed table in your instruction.
Does this return sample data?
The action can optionally include sample data. Request it only if you need it and the table contains data suitable for the run report.
When this happens · Trigger
Do this · Action
Supported Triggers and Actions
Notis builds workflows that link AccuWeather to ClickHouse. A trigger fires from one place; an action lands in another.
AccuWeather 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.
AccuWeather 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.