Is there any restriction using an "IN" clause with S3 Select?
Too limit data in Lambda function, I was planning to stream IDs from Dataset 1 using S3Select, and then use this dataset as the set of IDs to filter for the stream of Dataset 2 (also from S3Select).
So the S3Select query for Dataset 2 would be something like "Select * FROM Dataset1 WHERE ID IN (Dataset2)".
Would that work?
Hi, I d appreciate if below answer, if helped you, can be accept it so that resolution is clear for community when searching for similar questions, thanks!