See which weather tables are available
A scheduled inventory gives your team a simple way to see the tables available for weather analysis.
Trigger
Recurring schedule
Notis starts this workflow on a schedule, such as daily, weekly, or during business hours.
Action
List ClickHouse Tables
Lists tables in databases with basic details.
Why this helps
Finding the right table can interrupt analysis when database contents have changed or are unfamiliar.
- Review table names and available metadata in one report.
- Notice when the database inventory changes between scheduled runs.
- Spend less time manually browsing database contents.
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 the table inventory.
- 3Tell Notis to list tables in your specified ClickHouse database and summarize the returned table metadata for weather analysis.
- 4Pick a recurring schedule, choose where run reports go, and save the automation.
- 5Test with one real example and confirm that the listed tables match the database.
Questions about this workflow
Does this discover tables across every database?
The list action works with ClickHouse databases. Specify the database you want inventoried in your instruction.
Will the inventory show row counts?
The action returns table information including engine, size, and row count when available.
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.