Is there any trigger service available like mysql after insert trigger?

Plugins Alerting
1

Versions (relevant - OpenSearch/Dashboard/Server OS/Browser):
opensearch 2.3

Describe the issue:
Is there any trigger service available like mysql after insert trigger?

Thanks

2

Hello @sankar - welcome to the OpenSearch community.

I’m not aware of any, but, can you give a little more detail on what you’re looking for / trying to accomplish? thanks

3

Let me brief my requirement - I have two indices in opensearch. In first index I store my user data using kinesis firehose. so some user data might not immediately available in first index.

To our lambda some user information request will be sent as payload from thirdparty. If any particular user id not found in first index, then we will store this into second index.

so whenever new data pushed into first index, I need to cross check that this new data with second index document.

If mysql like after insert trigger is there then it would be easier for me to crosscheck with second index document whenever new data inserted into first index

4

There isn’t “sql trigger-like” functionality afaik.

1 Like