I have several athena databases and tables partitioned by date. I would like to move the underlying S3 buckets to different storage classes depending on how often these tables are queried. I am considering enabling S3 Storage Class Analysis on the underlying buckets of these tables. I wanted to know if queries to Athena on these tables / partitions will show up when viewing the data access pattern of the underlying S3 buckets using Amazon S3 Analytics. For example if I query an athena table 10 times and view the underlying S3 bucket's analytics, will it show that I viewed the S3 bucket 10 times?
Thanks
Yes, queries from Athena will be considered in the storage class analysis. Behind the scenes Athena makes regular LIST and GET operations against your S3 buckets.
You can verify this either by enabling logging in S3, or enabling object level logging for the bucket in CloudTrail.