Capture
Wait for change data capture event on Microsoft SQL Server and capture the event as an internal storage file.
Capture
Wait for change data capture event on Microsoft SQL Server and capture the event as an internal storage file.
yaml
type: "io.kestra.plugin.debezium.sqlserver.Capture"Examples
yaml
id: mysql_capture
namespace: company.team
tasks:
- id: capture
type: io.kestra.plugin.debezium.mysql.Capture
snapshotMode: NEVER
hostname: 127.0.0.1
port: "3306"
username: "{{ secret('MYSQL_USERNAME') }}"
password: "{{ secret('MYSQL_PASSWORD') }}"
maxRecords: 100
Properties
database *Requiredstring
hostname *Requiredstring
port *Requiredstring
deleted string
Default
ADD_FIELDPossible Values
ADD_FIELDNULLDROPdeletedFieldName string
Default
deletedexcludedColumns object
excludedDatabases object
excludedTables object
format string
Default
INLINEPossible Values
RAWINLINEWRAPignoreDdl booleanstring
Default
trueincludedColumns object
includedDatabases object
includedTables object
key string
Default
ADD_FIELDPossible Values
ADD_FIELDDROPmaxDuration string
maxRecords integerstring
maxSnapshotDuration string
Default
PT1HmaxWait string
Default
PT10Smetadata string
Default
ADD_FIELDPossible Values
ADD_FIELDDROPmetadataFieldName string
Default
metadataoffsetsCommitMode string
Default
ON_STOPPossible Values
ON_EACH_BATCHON_STOPpassword string
properties object
SubTypestring
snapshotMode string
Default
INITIALPossible Values
INITIALINITIAL_ONLYSCHEMA_ONLYsplitTable string
Default
TABLEPossible Values
OFFDATABASETABLEstateName string
Default
debezium-stateusername string
Outputs
size integer
stateHistoryKey string
stateOffsetKey string
uris object
SubTypestring