Skip to content
Notis

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.

TriggerScheduled

Execute ClickHouse Query

Runs a SQL query in ClickHouse, including queries that modify data or schema.

ActionInstant

Webhook trigger

Notis starts this workflow when an external tool or custom backend sends an HTTP request.

TriggerInstant

Get Database Schema

Retrieves a ClickHouse database schema overview and optionally its column definitions.

ActionInstant

Get Table Schema

Gets the schema and column details for a table.

ActionInstant

Get ClickHouse Play Interface

Returns the ClickHouse Play interface for writing queries and viewing results.

ActionInstant

List ClickHouse Databases

Lists the databases in an instance.

ActionInstant

List ClickHouse Tables

Lists tables in databases with basic details.

ActionInstant

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.