How do I get a list of my most expensive AWS buckets?

Tony

Is there a query for the Top 10 AWS S3 Buckets by Size and Cost?

jasmine_hex

find aws_s3_bucket with bucketSizeBytes!=undefined as bucket 
return 
    bucket.name, bucket.tag.AccountName, 
    bucket.numberOfObjects, bucket.bucketSizeBytes, 
    bucket.bucketSizeBytes / 1000000000 * 0.023 as monthlyCost,
    bucket.lifecycleEnabled, bucket.retentionPeriod, bucket.webLink
order by bucket.bucketSizeBytes DESC limit 10

jamegill

Nice!  Is there a way to also identify the storage class(es) within those buckets?

crystralRamirez

We can currently check to see if the S3 lifecycle has been enabled with the following query: 

FIND aws_s3_bucket with lifecycleEnabled = true

However, further integration work needs to be completed in order for us to see the lifecycle transitions. I just put in a feature request for this.