Check your analytics database after an Algolia index update
When your system reports an index update, request a broad ClickHouse schema overview to help you assess analytics impact.
Trigger
Webhook received
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Action
Get Database Schema
Retrieves a ClickHouse database schema overview and optionally its column definitions.
Why this helps
Index updates can prompt analytics follow-up, but database structure and the context for that change are easy to lose track of.
- Start a schema review from an HTTP request sent by your system.
- Get an overview of available databases and tables’ structure from ClickHouse.
- Use the request context to make the review more relevant.
Setup
Build it in a few focused steps.
- 1Connect Algolia and ClickHouse once in the Notis portal.
- 2Create an automation in Automations, New Automation, and add a name and Prompt.
- 3Tell Notis to use the Webhook payload as context and request a ClickHouse database schema overview relevant to the index update.
- 4Choose the Webhook trigger and where run reports should go.
- 5Send one real update notification to test the schema overview.
Questions about this workflow
Does Algolia send the Webhook automatically?
No Algolia trigger is listed. Your external tool or backend must send the HTTP request that starts this automation.
Does the schema overview prove an index change affected a ClickHouse table?
No. It provides database structure. To confirm a relationship or change, the relevant history or evidence must be available in the payload or your data.
Can I ask for column definitions too?
The database schema action can optionally include column definitions. State that request in your Prompt.
When this happens · Trigger
Do this · Action
Retrieves a ClickHouse database schema overview and optionally its column definitions.
Supported Triggers and Actions
Notis builds workflows that link Algolia to ClickHouse. A trigger fires from one place; an action lands in another.
Algolia 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 SQL query in ClickHouse, including queries that modify data or schema.
Webhook trigger
Notis starts this workflow when an external tool or custom backend sends an HTTP request.
Get Database Schema
Retrieves a ClickHouse database schema overview and optionally its column definitions.
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.
Algolia and ClickHouse, or any other combination from 1,600+ 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.