1 réponse
- Le plus récent
- Le plus de votes
- La plupart des commentaires
1
This article has generic info applicable to VPC Flow Logs, especially about partiioning and querying - https://www.linkedin.com/pulse/using-athena-partition-projection-query-cloudtrail-other-kinsman/.
It's hard to be sure from the image you pasted, but it looks like you've both set LOCATION to a specific date "2023/03/01/" and partitioned by date? That doesn't look right.
What query did you try?
Contenus pertinents
- demandé il y a un an
- demandé il y a 3 mois
- demandé il y a 6 mois
- AWS OFFICIELA mis à jour il y a 2 ans
- AWS OFFICIELA mis à jour il y a 6 mois
- AWS OFFICIELA mis à jour il y a 2 ans
I tired both "s3://.../2023/" and "s3://.../2023/03/01/". They return the same results. I just did it again and I'll add the screenshot in the original post.
I tried the "ALTER TABLE vpc_flow_logs ADD PARTITION (
date
='YYYY-MM-dd') LOCATION ..." query but the results were unreadable.I'm trying out the LinkedIn article right now.
Thanks!
Should have used s3://.../{location}/