Skip to content

Instantly share code, notes, and snippets.

@chilledornaments

chilledornaments/athena_query.sql

Created May 24, 2022 20:40
Show Gist options
  • Save chilledornaments/373de1f0dc584b21ac9b24756006d2aa to your computer and use it in GitHub Desktop.
Save chilledornaments/373de1f0dc584b21ac9b24756006d2aa to your computer and use it in GitHub Desktop.
Download ZIP
Most recently updated item per bucket. Produced by consolidated S3 Inventory
Raw
athena_query.sql
SELECT DISTINCT(bucket),
MAX(last_modified_date) AS last_modified_date
FROM s3_inventory
WHERE dt = '2022-05-23'
GROUP BY bucket
ORDER BY last_modified_date DESC
limit 500
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment