Hi All,
We are facing issue with our filter used in matillion DPC .
Import_timestamp >= ‘current_date()-7’
the above condition was working fine until yesterday (11th nov) . today it started failing with following error
Timestamp ‘current_date()-7’ is not recognized;
Did anyone faced this issue. since number of mappings using the above filter condition and if start manual fix it will be time consuming process.
I have the same Issue, all the jobs where we filter a DATETIME got failed in prod & dev environment today. Would be good with some explaination from Matillion regarding this.
First of all, a very warm welcome to the Matillion Community, @baskar.arumugam and @patrik.ekman! Thanks for posting.
I’ve escalated your issues with the team, and we’re looking into them. I’ll update you both here as soon as there’s a solution.
Many thanks, and kind regards,
Suzanne.