Capture

type: "io.kestra.plugin.debezium.postgres.Capture"

Examples

id: "capture"
type: "io.kestra.plugin.debezium.postgres.Capture"
hostname: 127.0.0.1
port: "5432"
username: psql_user
password: psql_passwd
maxRecords: 100
database: my_database
pluginName: PGOUTPUT
snapshotMode: ALWAYS

Properties

database

• Type: string
• Dynamic: ✔️
• Required: ✔️

deleted

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: ADD_FIELD
• Possible Values:
  • ADD_FIELD
  • NULL
  • DROP

deletedFieldName

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: deleted

format

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: INLINE
• Possible Values:
  • RAW
  • INLINE
  • WRAP

hostname

• Type: string
• Dynamic: ✔️
• Required: ✔️

ignoreDdl

• Type: boolean
• Dynamic: ❌
• Required: ✔️
• Default: true

key

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: ADD_FIELD
• Possible Values:
  • ADD_FIELD
  • DROP

metadata

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: ADD_FIELD
• Possible Values:
  • ADD_FIELD
  • DROP

metadataFieldName

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: metadata

pluginName

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: PGOUTPUT
• Possible Values:
  • DECODERBUFS
  • WAL2JSON
  • WAL2JSON_RDS
  • WAL2JSON_STREAMING
  • WAL2JSON_RDS_STREAMING
  • PGOUTPUT

port

• Type: string
• Dynamic: ✔️
• Required: ✔️

publicationName

• Type: string
• Dynamic: ✔️
• Required: ✔️
• Default: kestra_publication

slotName

• Type: string
• Dynamic: ✔️
• Required: ✔️
• Default: kestra

snapshotMode

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: INITIAL
• Possible Values:
  • INITIAL
  • ALWAYS
  • NEVER
  • INITIAL_ONLY

splitTable

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: TABLE
• Possible Values:
  • OFF
  • DATABASE
  • TABLE

stateName

• Type: string
• Dynamic: ❌
• Required: ✔️
• Default: debezium-state

excludedColumns

• Type: object
• Dynamic: ✔️
• Required: ❌

excludedDatabases

• Type: object
• Dynamic: ✔️
• Required: ❌

excludedTables

• Type: object
• Dynamic: ✔️
• Required: ❌

includedColumns

• Type: object
• Dynamic: ✔️
• Required: ❌

includedDatabases

• Type: object
• Dynamic: ✔️
• Required: ❌

includedTables

• Type: object
• Dynamic: ✔️
• Required: ❌

maxDuration

• Type: string
• Dynamic: ❌
• Required: ❌
• Format: duration

maxRecords

• Type: integer
• Dynamic: ❌
• Required: ❌

maxSnapshotDuration

• Type: string
• Dynamic: ❌
• Required: ❌
• Default: 3600.000000000
• Format: duration

maxWait

• Type: string
• Dynamic: ❌
• Required: ❌
• Default: 10.000000000
• Format: duration

password

• Type: string
• Dynamic: ✔️
• Required: ❌

properties

• Type: object
• SubType: string
• Dynamic: ✔️
• Required: ❌

sslCert

• Type: string
• Dynamic: ✔️
• Required: ❌

sslKey

• Type: string
• Dynamic: ✔️
• Required: ❌

sslKeyPassword

• Type: string
• Dynamic: ✔️
• Required: ❌

sslMode

• Type: string
• Dynamic: ❌
• Required: ❌
• Default: DISABLE
• Possible Values:
  • DISABLE
  • REQUIRE
  • VERIFY_CA
  • VERIFY_FULL

sslRootCert

• Type: string
• Dynamic: ✔️
• Required: ❌

username

• Type: string
• Dynamic: ✔️
• Required: ❌

Outputs

size

• Type: integer
• Required: ❌

stateHistoryKey

• Type: string
• Required: ❌

stateOffsetKey

• Type: string
• Required: ❌

uris

• Type: object
• SubType: string
• Required: ❌