FlowDSL Node Catalog

ClickHouse Query

Run a SELECT statement and emit rows as `items`.

Overview

PropertyValue
Node IDclickhouse/query
Kindtransform
Moduleclickhouse-flowdsl
Repogo-module-clickhouse
Handlergithub.com/redelay/go-module-clickhouse/flowdsl.Query
Iconlucide:search
Color#facc15
Tagsclickhouse, read

Outputs

  • out — (no description)

Settings

PropertyTypeRequiredDefaultUI GroupDescription
outputKeystring—itemsOutput
paramsPathstring——QueryDotted packet path to an array of bind params.
sqlstringyes—QueryParameterized SQL. Use $1, $2… for bind params.

Example

yaml
# Use this node in a flow:
nodes:
  - id: my_step
    name: My Step
    kind: transform
    action_ref: clickhouse/query
    config:
      outputKey: items
      paramsPath: some.packet.path
      sql: "value"