
Capture
Capture
yaml
type: "io.kestra.plugin.debezium.postgres.Capture"Examples
yaml
id: pg_capture
namespace: company.team
tasks:
- id: capture_data
type: io.kestra.plugin.debezium.postgres.Capture
hostname: 127.0.0.1
port: "5432"
username: "{{ secret('PG_USERNAME') }}"
password: "{{ secret('PG_PASSWORD') }}"
maxRecords: 100
database: my_database
pluginName: PGOUTPUT
snapshotMode: ALWAYS
Properties
database*Requiredstring
hostname*Requiredstring
port*Requiredstring
deletedstring
Default
ADD_FIELDPossible Values
ADD_FIELDNULLDROPdeletedFieldNamestring
Default
deletedexcludedColumnsobject
excludedDatabasesobject
excludedTablesobject
formatstring
Default
INLINEPossible Values
RAWINLINEWRAPignoreDdlbooleanstring
Default
trueincludedColumnsobject
includedDatabasesobject
includedTablesobject
keystring
Default
ADD_FIELDPossible Values
ADD_FIELDDROPmaxDurationstring
Format
durationmaxRecordsintegerstring
maxSnapshotDurationstring
Default
PT1HFormat
durationmaxWaitstring
Default
PT10SFormat
durationmetadatastring
Default
ADD_FIELDPossible Values
ADD_FIELDDROPmetadataFieldNamestring
Default
metadataoffsetsCommitModestring
Default
ON_STOPPossible Values
ON_EACH_BATCHON_STOPpasswordstring
pluginNamestring
Default
PGOUTPUTPossible Values
DECODERBUFSWAL2JSONWAL2JSON_RDSWAL2JSON_STREAMINGWAL2JSON_RDS_STREAMINGPGOUTPUTpropertiesobject
SubTypestring
publicationNamestring
Default
kestra_publicationslotNamestring
Default
kestrasnapshotModestring
Default
INITIALPossible Values
INITIALALWAYSNEVERINITIAL_ONLYsplitTablestring
Default
TABLEPossible Values
OFFDATABASETABLEsslCertstring
sslKeystring
sslKeyPasswordstring
sslModestring
Default
DISABLEPossible Values
DISABLEREQUIREVERIFY_CAVERIFY_FULLsslRootCertstring
stateNamestring
Default
debezium-stateusernamestring
Outputs
sizeinteger
stateHistoryKeystring
stateOffsetKeystring
urisobject
SubTypestring