How to keep only one version of an index / rebuild index each jdbc input

[hzdb5betrieb]

hello,

we want to sync a table from an oracle database into an elasticsearch index with logstash jdbc input.
the data is not timeseries data, we want to keep only one index with the current table entries (the ones from of the last jdbc input select).

we define a static index "static-table-data-v01" in the elasticoutput.
the problem is, if rows are deleted in the table, it is not removed from the elasticsearch index.

how could this be achieved?

many thanks for your help and thoughts.

regards,
stefan.

output {
  elasticsearch {
    hosts => ["https://${ES_HOST}:9200"] ssl => true
    ssl_certificate_verification => true
    cacert => "xy"

    index => "static-table-data-v01"
    document_id => "%{column1}"

    user => "xxx"
    password => "zzz"
  }
}