I'm curious if anyone has experience with updating partitions in S3 path...
Currently, we have files stored in S3 under the following path s3://bucket/table-name/year=/month=. Glue/Athena table detects this as a year and month partition.
At some point in the future, we believe business partner could request for daily files. This would mean we need to update s3 path to be s3://bucket/table-name/year=/month=/day=. This way we would have files stored down to day partition/grain.
Is this even possible or will we need to reprocess existing files stored under s3://bucket/table-name/year=/month= and force them into a day folder?
