Hi everyone,
I have an transform that suppose to track the latest doc of some index.
The transform I made is based on field called "etl_id" and for some reason it is updated only for few "etl_id" but not all of them, here is an example of some doc that was not updated in the transform:
source index (etl_logs):
{
"_index": "etl_logs",
"_id": "C1FKPI0BOAhJ8yM6psQ7",
"_score": null,
"_source": {
"level": "INFO",
"host": "host1",
"etl_filename": "etl.py",
"etl_id": "1988",
"items_processed": 1,
"log_data": "",
"timestamp": "2024-01-24T18:25:41+03:00"
}
transform index (latest_etl_log):
{
"_index": "latest_etl_log",
"_id": "MYWbD3aM_AEJlF6WStE10ckAAAAAAAAA",
"_score": null,
"_source": {
"items_processed": 1,
"etl_id": "1988",
"level": "INFO",
"etl_filename": "etl.py",
"host": "host1",
"log_data": "",
"timestamp": "2024-01-22T16:52:57+03:00"
}
And here is the transform settings:
{
"count": 1,
"transforms": [
{
"id": "latest_etl_log",
"authorization": {
"roles": [
"superuser"
]
},
"version": "8.7.1",
"create_time": 1705401981779,
"source": {
"index": [
"etl_logs"
],
"query": {
"match_all": {}
}
},
"dest": {
"index": "latest_etl_log"
},
"sync": {
"time": {
"field": "timestamp",
"delay": "60s"
}
},
"latest": {
"unique_key": [
"etl_id.keyword"
],
"sort": "timestamp"
},
"settings": {}
}
]
}
Any ideas what can be the problem? why some of the etl_id are updated correctly and the others stays behind?