How to filter (SQL Query) a datasets by timestamp from Lambda function

I am trying to filter a datasets by timestamp from Lambda function.
For example, It needs to update newest date between today and a week ago everyday.
That is why I am trying to use Lambda function with trigger and pass a SQL query to Filter of Datasets.

  • I am using S3 buckets here as database.

Is it able to implement? or Any other suggestions?

HI @Kito

not totaly getting your case. but how dynamic is the filter criteria or is it always date between today and a week ago everyday?

BR

Hi @Kito,
It’s been awhile since we last heard from you, did you have any additional questions regarding your initial topic?

If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.

Thank you!

Hi @Kito,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!