Read trailing 14 days data from a partitioned S3 location as /load_date=YYYY-MM-DD/load_hour=HH

Ankita

I want to read the trailing 14 days data from S3. I have already setup my S3 connection and want to read data for last 14 days load date and only the 24th load_hour. How can I apply filter just while reading the S3 location using S3 connection setup.
Since I need to do it for multiple data sources reading it individually is a big task where in I had to manually read these dates for all the 11 data sources.