RealtimeTrigger
yaml
type: "io.kestra.plugin.debezium.sqlserver.RealtimeTrigger"
Consume a message from a SQL Server database via change data capture in real-time.
yaml
id: debezium-sqlserver
namespace: company.team
tasks:
- id: send_data
type: io.kestra.plugin.core.log.Log
message: "{{ trigger.data }}"
triggers:
- id: realtime
type: io.kestra.plugin.debezium.sqlserver.RealtimeTrigger
hostname: 127.0.0.1
port: 61433
username: sa
password: password
database: deb
Dynamic YES
Dynamic YES
Default ADD_FIELD
Possible Values
ADD_FIELDNULLDROP
Dynamic YES
Default deleted
Dynamic YES
Default INLINE
Possible Values
RAWINLINEWRAP
Dynamic YES
Dynamic YES
Default true
Dynamic YES
Default ADD_FIELD
Possible Values
ADD_FIELDDROP
Dynamic YES
Default ADD_FIELD
Possible Values
ADD_FIELDDROP
Dynamic YES
Default metadata
Dynamic YES
Dynamic YES
Default INITIAL
Possible Values
INITIALINITIAL_ONLYSCHEMA_ONLY
Dynamic YES
Default TABLE
Possible Values
OFFDATABASETABLE
Dynamic YES
Default debezium-state
Dynamic YES
Dynamic YES
Dynamic YES
Dynamic YES
Dynamic YES
Dynamic YES
Dynamic YES
Default ON_EACH_BATCH
Possible Values
ON_EACH_BATCHON_STOP
Dynamic YES
SubType string
Dynamic YES
Dynamic NO
SubType string
Dynamic NO
Possible Values
CREATEDRUNNINGPAUSEDRESTARTEDKILLINGSUCCESSWARNINGFAILEDKILLEDCANCELLEDQUEUEDRETRYINGRETRIEDSKIPPED
List of execution states after which a trigger should be stopped (a.k.a. disabled).
Dynamic YES