ClickHouse Trigger icon

ClickHouse Trigger

Triggers a workflow when new rows appear or data changes in a ClickHouse table

ClickHouse Trigger

AI-generated

Summary

Poll ClickHouse for new or changed rows based on configured mode.

Inputs

  • pollTimes — Time at which polling should occur.
  • mode — Trigger mode: detect new rows by tracking column or run a custom SELECT query.
  • table (required) — Table name to poll.
  • trackingColumn (required) — Monotonically increasing column used to detect new rows.
  • selectColumns — Comma-separated list of columns to return; defaults to all.
  • query (required) — Custom SELECT query; use {lastValue} placeholder for the tracked value.
  • options — Collection of additional options such as database override, limit, and initial tracking value.

Output shape

array of objects

Each object represents a row with selected columns; the result may be empty if no new rows are found.

Examples

Example 1: Trigger on new rows in the 'events' table using default settings.

mode: New Rows, table: events, trackingColumn: id, limit: 1000, query: "SELECT * FROM events WHERE id > '{lastValue}' ORDER BY id"

Links

Discussion