How to do Cloud Storage Validation

[jmaatheus]

In my storage I have several folders that represent tables in my database, they are fed via Kafka.

Within each main folder, there are subfolders representing the year, month and day.

I need a way to validate the last subfolder.

Is this possible through query?

Example:

SELECT FOLDER, MAX(SUBFOLDER)
  FROM STORAGE