I’ve received some rollup knowledge that I create each evening and retailer in an S3 bucket, partitioned by date. I execute an
ALTER TABLE foo ADD PARTITION... so as to add every new partition to Athena because it’s created. I have been capable of confirm that this efficiently provides the information and that I can question it in Athena. Thus far, so good.
What I might love to do now could be have knowledge older than 30 days mechanically roll off. I can arrange a lifecycle rule to drop the previous knowledge from S3; will this additionally mechanically take away it from Athena, or do I have to take direct motion in Athena itself to take away it from the desk as effectively?
It appears to work as I anticipate once I merely take away the partition in S3, however I am unable to discover something definitive that claims that is the beneficial option to deal with this.