'Custom Metrics of AWS to display how many newly uploaded files in the folders every day

As title, is it a correct answer since I'm so sure whether we can put directory to a folder as the bucket name:

SELECT COUNT(NumberOfObjects) FROM SCHEMA("AWS/S3", BucketName,StorageType) 
WHERE BucketName = 'pbr-data-lake-dev/data/raw/A' AND BucketName = 'pbr-data-lake-dev/data/raw/B' AND BucketName = 'pbr-data-lake-dev/data/raw/C'
GROUP BY BucketName


Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source