S3 object count using Athena CuR

0

Customer is migrating their s3 buckets from one account to another one. They have multiple accounts and each account has around 170 buckets. Many buckets have millions of objects stored. Customer is looking for a way to get the object count for each account in a single csv format, to make sure that the data is migrated correctly to new account buckets. Is there any way to get the object count using the athena query to CuR?

AWS
TejasM
posta 4 anni fa500 visualizzazioni
1 Risposta
0
Risposta accettata

I suspect that CloudWatch metrics may be a better mechanism to create your reference file: https://docs.aws.amazon.com/AmazonS3/latest/dev/cloudwatch-monitoring.html

As you'll see on that page you can use the Daily Storage Metrics to return the NumberOfObjects per bucket.

You could then write some code to iterate over the regions and buckets returning the number of objects and building your reference file.

AWS
Colin_M
con risposta 4 anni fa

Accesso non effettuato. Accedi per postare una risposta.

Una buona risposta soddisfa chiaramente la domanda, fornisce un feedback costruttivo e incoraggia la crescita professionale del richiedente.

Linee guida per rispondere alle domande