JDBC Postgres Sink Connector Config

jdbc_sink_connector.json

{
  "name": "newuser",
  "connector.class": "io.debezium.connector.jdbc.JdbcSinkConnector",
  "tasks.max": "1",
  "connection.url": "jdbc:postgresql://${MASTER_DB_HOST}:${MASTER_DB_PORT}/${MASTER_DB_NAME}",
  "connection.username": "${MASTER_DB_USER}",
  "connection.password": "${MASTER_DB_PASSWORD}",
  "insert.mode": "upsert",
  "delete.enabled": "true",
  "primary.key.mode": "record_key",
  "primary.key.fields": "id",
  "schema.evolution": "basic",
  "auto.evolve": "true",
  "database.time_zone": "UTC",
  "topics": "user.public.user",
  "table.name.format": "new_user",
  "transforms": "filterFields",
  "transforms.filterFields.type": "org.apache.kafka.connect.transforms.ReplaceField$Value",
  "transforms.filterFields.whitelist": "name,avatar"
}