Athena 㧠CloudTrail ã®ã‚¤ãƒ™ãƒ³ãƒˆã‚’集計ã™ã‚‹ - ablog
CloudTrail ã‚’ S3 ã«ä¿å˜ã—ã¦ãŠã（è¨å®šæ–¹æ³•ã¯ã‚³ãƒãƒ©ï¼‰ã€Athena ã§é›†è¨ˆã—ã¦ã¿ãŸã€‚ eventsource ã§é›†è¨ˆ select eventsource, count(1) as cnt from default.cloudtrail_logs_cloudtrail_do_not_delete group by eventsource order by cnt desc eventsource count s3.amazonaws.com 1111063 ec2.amazonaws.com 86762 sts.amazonaws.com 52597 athena.amazonaws.com 10359 ssm.amazonaws.com 8277 glue.amazonaws.com 2114 cloudformation.amazonaws.com 1882 kms.am
AWS Lambda 㧠Amazon Athena ã®ã‚¯ã‚¨ãƒªã‚’実行ã—ã¦S3ã®ãƒ‡ãƒ¼ã‚¿ã‚’å–å¾—ã™ã‚‹ | DevelopersIO
Lambda(Python3.6)ã‹ã‚‰Athenaを実行ã™ã‚‹æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã®ã§ã‚µãƒ³ãƒ—ルコードをã”紹介ã—ã¾ã™ã€‚ Overview Event発生時ã«ã‚ーã¨ãªã‚‹æƒ…å ±ã‚’å—ã‘å–ã‚Š AWS Lambda ãŒå®Ÿè¡Œã•ã‚Œã‚‹ Amazon Athenaã§ã‚¯ã‚¨ãƒªã‚’実行ã—実行çµæžœã‚’å–å¾—ã™ã‚‹ Athena実行時ã«ä½œæˆã•ã‚ŒãŸS3オブジェクトã¯å‰Šé™¤ã™ã‚‹ s3 data s3 ã«ã‚るデータã¯ä»¥ä¸‹ã¨ã—ã¾ã™ã€‚ {"name":"user1","email":"[email protected]"} {"name":"user2","email":"[email protected]"} {"name":"user3","email":"[email protected]"} AWS Lambda Sample Code 呼ã³å‡ºã•ã‚Œã‚‹ã¨ãã«nameã®æƒ…å ±ã‚’å–å¾—ã—Athenaã§ã‚¯ã‚¨ãƒªã‚’実行ã—ã¦ãƒ¬ã‚¹ãƒãƒ³ã‚¹æƒ…å ±ã‚’è¿”ã—ã¾ã™ã€‚ im
1
リリースã€éšœå®³æƒ…å ±ãªã©ã®ã‚µãƒ¼ãƒ“スã®ãŠçŸ¥ã‚‰ã›
最新ã®äººæ°—エントリーã®é…ä¿¡
処ç†ã‚’実行ä¸ã§ã™
j次ã®ãƒ–ックマーク
kå‰ã®ãƒ–ックマーク
lã‚ã¨ã§èªã‚€
eコメント一覧を開ã
oページを開ã
{{#tags}}- {{label}}
{{/tags}}