Using Folder name and Filename for values

Question & Answer
1

Hi Team,

The data is extracted in separate files for each region and uploaded in a separate folder for extract date in the s3 bucket.

I want to analyse data over time using the date from the folder name and region from the file name

Is this possible? If so, how?

2

Hi @huzefa.h89 QuickSight would not be able read the metadata such as the file or folder name, but when you are extracting the data you could add two columns in each file, one for region and one for date.
If you are querying your S3 bucket using Athena, you may also be able to query the path and extract the values from that, as in this document