I have an SQS FIFO queue that I want to use a trigger an orchestration job. I already have everything set up and the messages land in the queue, I set up the listener in Matillion, but every time the message is received nothing gets triggered in Matillion.
We usually log any message we receive via SQS. Please download your logs from Admin menu and look for any occurrence JSON with “BookSupportBI” which might be the message you are sending.
Just to be sure, please visit Project→ManageSQSConfiguration and see if you’ve got the correct SQS Queue selected under Listen.
Another useful test would be to create a new orchestration job and add a SQS component to it. Then Copy/Paste the JSON from lambda replacing new_key with the appropriate filename. Check if running this job will trigger job – ContactTraceRecords.