[B! Athena] mapk0yã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯

mapk0y id:mapk0y

Athenaã«é–¢ã™ã‚‹mapk0yã®ãƒ–ãƒƒã‚¯ãƒžãƒ¼ã‚¯ (34)

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

${{author_name}}$
{{author_name}}{{created}}
{{ #comment }}{{ comment }}{{ /comment }}
- {{ label }}

${{author_name}}$

{{{comment_expanded}}}

{{label}}

{{#is_bookmark}}ãƒªã‚¹ãƒˆ{{/is_bookmark}}{{^is_bookmark}}ãƒªãƒ³ã‚¯{{/is_bookmark}}

Amazon Athenaã‚’é«˜é€ŸåŒ–ï¼ãƒã‚±ãƒƒãƒ†ã‚£ãƒ³ã‚°ã¨ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã®é•ã„ - ã‚µãƒ¼ãƒãƒ¼ãƒ¯ãƒ¼ã‚¯ã‚¹ã‚¨ãƒ³ã‚¸ãƒ‹ã‚¢ãƒ–ãƒã‚°
ã¯ã˜ã‚ã« ä»Šæ—¥ã¯ã€Amazon Athena ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹æ–¹æ³•ã«ã¤ã„ã¦ã”ç´¹ä»‹ã—ã¾ã™ï¼ Athena ã¨ã¯ã€Amazon S3 ã«ä¿å˜ã•ã‚Œã¦ã„ã‚‹ãƒ‡ãƒ¼ã‚¿ã‚’ä¸å¿ƒã«ã€SQL ã‚’ä½¿ã£ã¦ã•ã¾ã–ã¾ãªãƒ‡ãƒ¼ã‚¿ã‚½ãƒ¼ã‚¹ã«ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã§ãã‚‹ã‚µãƒ¼ãƒ“ã‚¹ã§ã™ã€‚ ã‚¯ã‚¨ãƒªã®ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã•ã›ã‚‹æ–¹æ³•ã¯ã„ãã¤ã‹ã‚ã‚Šã¾ã™ãŒã€ãã®ä¸ã§ã‚‚åŠ¹æžœãŒå¤§ãã„ã®ãŒã€Œã‚¹ã‚ãƒ£ãƒ³ã™ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚’æ¸›ã‚‰ã™ã€ã“ã¨ã§ã™ã€‚ Athena ã®æ–™é‡‘ã¯ã‚¹ã‚ãƒ£ãƒ³ã—ãŸãƒ‡ãƒ¼ã‚¿é‡ã«å¿œã˜ã¦ç™ºç”Ÿã™ã‚‹ãŸã‚ã€ãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚’å‘ä¸Šã ã‘ã§ã¯ãªãã‚³ã‚¹ãƒˆã‚‚æœ€é©åŒ–ã§ãã¾ã™ã€‚ Athena ãŒã‚¹ã‚ãƒ£ãƒ³ã™ã‚‹å¿…è¦ãŒã‚ã‚‹ãƒ‡ãƒ¼ã‚¿é‡ã‚’æ¸›ã‚‰ã™ãŸã‚ã®æ–¹æ³•ã¨ã—ã¦ã€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã¨ãƒã‚±ãƒƒãƒ†ã‚£ãƒ³ã‚°ã¨ã„ã†ã‚‚ã®ãŒã‚ã‚Šã¾ã™ã€‚ ä»Šå›žã¯ã€ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã¨ãƒã‚±ãƒƒãƒ†ã‚£ãƒ³ã‚°ã‚’ã©ã®ã‚ˆã†ã«ä½¿ã„åˆ†ã‘ã€ä½µç”¨ã™ã‚Œã°ã‚ˆã„ã‹è§£èª¬ã—ã¾ã™ï¼ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã¨ã¯ ãƒ‘ãƒ¼ãƒ†ã‚£ã‚·ãƒ§ãƒ³ã¨ã¯ã€S3 ä¸Šã®ãƒ‡ãƒ¼ã‚¿ã‚’ãƒ•ã‚©ãƒ«ãƒ€ï¼ˆãƒ—ãƒ¬ãƒ•ã‚£ãƒƒ
mapk0y 2025/08/18
AWS

Athena
ãƒªãƒ³ã‚¯
Athena ã§ S3 ã¨ MySQL ã‚’ JOIN ã™ã‚‹ | DevelopersIO
ç›®çš„ ã‚¯ãƒ©ã‚¹ãƒ¡ã‚½ãƒƒãƒ‰ã‚¿ã‚¤ãƒ©ãƒ³ãƒ‰ã®æ¸…æ°´ã§ã™ã€‚ æœ¬è¨˜äº‹ã§ã¯ Amazon Athena ã‚’ä½¿ã£ã¦ã€S3 ã¨ MySQL ã‚’ JOIN ã™ã‚‹ã‚¯ã‚¨ãƒªã‚’ç™ºè¡Œã—ã¾ã™ã€‚ å¤§ã¾ã‹ã«ä»¥ä¸‹ã®ã‚ˆã†ãªæ§‹æˆã«ãªã‚Šã¾ã™ã€‚ å‰ææ¡ä»¶ãƒ»çŸ¥è˜ AWS ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã‚’ä½œæˆæ¸ˆã¿ IAM Role, Policy, Cloud9 ã®ç’°å¢ƒã‚’ä½œæˆã§ãã‚‹æ¨©é™ãŒã‚ã‚‹ ä½¿ã„ãŸã„AWS ã‚¢ã‚«ã‚¦ãƒ³ãƒˆã®ãƒªãƒ¼ã‚¸ãƒ§ãƒ³ã§ cdk bootstrap ã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œæ¸ˆã¿ aws cli ã®ä½¿ã„æ–¹ æ‰‹é † ç’°å¢ƒæ§‹ç¯‰ Cloud9 ã‚’ä½¿ã£ã¦ CDK ã‚’ãƒ‡ãƒ—ãƒã‚¤ã—ãŸã‚Šã€å¿…è¦ãªã‚³ãƒžãƒ³ãƒ‰ã‚’å®Ÿè¡Œã™ã‚‹ãŸã‚ã®ç’°å¢ƒã‚’æ§‹ç¯‰ã—ã¾ã™ã€‚ ã‚‚ã—æ‰‹å…ƒã«ç’°å¢ƒãŒã‚ã‚Œã°ã“ã®å·¥ç¨‹ã¯ã‚¹ã‚ãƒƒãƒ—ã—ã¦ã‚‚å•é¡Œã‚ã‚Šã¾ã›ã‚“ã€‚ ã¾ãšã¯ Cloud9 ã®ç’°å¢ƒãŒä½¿ã† EC2 ã‚¤ãƒ³ã‚¹ã‚¿ãƒ³ã‚¹ã«ã‚¢ã‚¿ãƒƒãƒã™ã‚‹ãƒãƒ¼ãƒ«ã‚’ä½œæˆã—ã¾ã™ã€‚ ãƒãƒ¼ãƒ«ã«ã¯ä»¥ä¸‹ã®ãƒãƒªã‚·ãƒ¼ã‚’é–¢é€£ä»˜ã‘ã¾ã™ã€‚ âš ï¸ æœ€å°æ¨©é™ã§ã¯ã‚ã‚Šã¾ã›ã‚“ã€‚å®Ÿéš›ã®ãƒ—ãƒã‚¸ã‚§ã‚¯ãƒˆã§
mapk0y 2024/05/12
Athena

MySQL
ãƒªãƒ³ã‚¯
AS59128 ã®ãƒ•ãƒãƒ¼æƒ…å ±åŽé›†ã¨ Amazon Athena ã§ã®åˆ†æž - KMCæ´»å‹•ãƒ–ãƒã‚°
ã“ã‚“ã«ã¡ã¯ã€ id:sora_h ã§ã™ã€‚ã“ã‚Œã¯ KMC Advent Calendar 2023 12 æ—¥ç›®ã®è¨˜äº‹ã§ã™ (å¤§é…åˆ»)ã€‚ KMC ã§ã¯ã‚¤ãƒ³ã‚¿ãƒ¼ãƒãƒƒãƒˆæŽ¥ç¶šæ‰‹æ®µã® 1 ã¤ã¨ã—ã¦ AS59128 ã‚’ 2017 å¹´é ƒã‚ˆã‚Šé‹ç”¨ã—ã¦ã€éƒ¨å®¤å†…ã®ã‚µãƒ¼ãƒãƒ¼ã‚„ä¸€éƒ¨ã®éƒ¨å“¡ãŒåˆ©ç”¨ã—ã¦ã„ã¾ã™ã€‚ã“ã‚Œã¾ã§ãƒ•ãƒãƒ¼æƒ…å ±ã®åŽé›†ã¯è¡Œã£ã¦ãã¾ã›ã‚“ã§ã—ãŸãŒã€ä»Šå¹´ã€ãƒ•ãƒãƒ¼æƒ…å ±ã®çµ±è¨ˆã‚’åŽé›†ã—ã¦åˆ†æžã‚’å¯èƒ½ã«ã—ãŸãŸã‚ã€ãã®å®Ÿè£…ã‚’è»½ãç´¹ä»‹ã—ã¾ã™ã€‚åœ°å‘³ã« pmacctd ã®ãƒ‰ã‚ãƒ¥ãƒ¡ãƒ³ãƒˆãŒé›£è§£ã ã£ãŸã®ã§â€¦ã€‚ çµŒç·¯ AS59128 ã¯é‹ç”¨åˆæœŸã‹ã‚‰è¤‡æ•°ã®ãƒˆãƒ©ãƒ³ã‚¸ãƒƒãƒˆã‚„ãƒ”ã‚¢ã€æ±è¥¿ã«è·¨ã£ãŸè¤‡æ•°æ‹ ç‚¹ãŒå˜åœ¨ã—ã¦ã„ã¾ã™ãŒã€å¤–éƒ¨ã®çµŒè·¯ç”±æ¥ã®éšœå®³ã‚„æ€§èƒ½åŠ£åŒ–ã«ã¤ã„ã¦ã®èª¿æŸ»ã¯ãƒ•ãƒãƒ¼æƒ…å ±ãªã—ã§å®Ÿæ–½ã—ã¦ã„ã¦ã€ç‰¹ã«å¤‰åŒ–å‰ã®ãƒˆãƒ©ãƒ•ã‚£ãƒƒã‚¯ã‚’ç¢ºèªã™ã‚‹ã“ã¨ãŒãã‚Œãªã—ã§ã¯é›£ã—ãã‚¨ã‚¹ãƒ‘ãƒ¼ã‚’ç¹°ã‚Šè¿”ã—ã¦ã¾ã—ãŸã€‚ ã“ã®ã¾ã¾ã§ã¯éšœå®³æ™‚ã®å¯¾å¿œãŒæ‰‹æŽ¢ã‚Šã§å®‰å®šé‹ç”¨ã«æ”¯éšœãŒã‚ã‚‹ã€ã¾ãŸ (
mapk0y 2023/12/25
Athena
ãƒªãƒ³ã‚¯
Query and analyze Amazon S3 data with the new Amazon Athena plugin for Grafana | Grafana Labs
Query and analyze Amazon S3 data with the new Amazon Athena plugin for Grafana This blog post was co-authored by Sarah Zinger, Software Engineer in R&D at Grafana who works as part of the cloud data sources squad that builds open source data source plugins to connect Grafana with major cloud providers, and Robbie Rolins, a Software Development Engineer on the Amazon Managed Grafana team. In collab
mapk0y 2022/02/16
AWS

grafana

Athena
ãƒªãƒ³ã‚¯
Using Athena in Amazon Managed Grafana - AWS Observability Recipes
mapk0y 2022/02/16
AWS

Athena

Grafana
ãƒªãƒ³ã‚¯
Michael Hausenblas on Twitter: "Check out what we just launched in Amazon Managed Grafana: from new plugins for Athena, Redshift, Geomap, Cloudflarâ€¦ https://t.co/kvdXqnrjhS"
mapk0y 2022/02/16
AWS

Grafana

Athena
ãƒªãƒ³ã‚¯
AWS Config ã®æ–™é‡‘ãŒãªãœã“ã‚“ãªã«é«˜ã„ï¼Ÿ Amazon Athena ã§ã©ã®ãƒªã‚½ãƒ¼ã‚¹ãŒ Config ã®è¨˜éŒ²å¯¾è±¡ã«ãªã£ã¦ã„ã‚‹ã‹èª¿ã¹ã¦ã¿ãŸ | DevelopersIO
AWS Config ã®æ–™é‡‘ãŒãªãœã“ã‚“ãªã«é«˜ã„ï¼Ÿ Amazon Athena ã§ã©ã®ãƒªã‚½ãƒ¼ã‚¹ãŒ Config ã®è¨˜éŒ²å¯¾è±¡ã«ãªã£ã¦ã„ã‚‹ã‹èª¿ã¹ã¦ã¿ãŸ AWS Config ã® configuration it em recorded ã®å†…è¨³ã‚’ãƒžãƒã‚¸ãƒ¡ãƒ³ãƒˆã‚³ãƒ³ã‚½ãƒ¼ãƒ«ã‹ã‚‰ç¢ºèªã™ã‚‹ã®ã¯éª¨ãŒæŠ˜ã‚Œã¾ã™ã€‚ Amazon Athena ã§ã‚¯ã‚¨ãƒªã—ã¦ãŠæ‰‹è»½ã«ç¢ºèªã—ã¾ã—ã‚‡ã†ã€‚ ã ã„ã˜ã‚‡ã†ã¶ Athena ã“ã‚ããªã„ã€‚
mapk0y 2021/09/26
Athena

AWS
ãƒªãƒ³ã‚¯
S3ã«ä¿å˜ã—ãŸ AWS WAFãƒã‚°ã‚’ Athenaã§åˆ†æžã—ã¦ã¿ã‚‹ | DevelopersIO
2022/03/09 æ›´æ–°: WAFã®ã‚¢ãƒƒãƒ—ãƒ‡ãƒ¼ãƒˆã‚‚ã‚ã‚Šã“ã®æƒ…å ±ã¯å¤ããªã£ã¦ã„ã¾ã™ã€‚ä»¥ä¸‹ãƒ–ãƒã‚°ã‚’ä»£ã‚ã‚Šã«å‚ç…§ãã ã•ã„ã€‚ æ¦‚è¦ æ§‹æˆå›³ã¯ä¸‹è¨˜ã®ã¨ãŠã‚Šã§ã™ã€‚ ALBãƒ»EC2ã‹ã‚‰ãªã‚‹ Webã‚µãƒ¼ãƒã‚’ä½œæˆã—ã¾ã™ WAFã‚’ ALBã«é–¢é€£ä»˜ã‘ã¾ã™ WebACLã«ã¯ ä»¥ä¸‹ 3ãƒ«ãƒ¼ãƒ«ã‚’é©ç”¨ã•ã›ã¾ã™ SQL injection match condition cross-site scripting match condition string match condition Kinesis Data Firehoseã§ WAFãƒã‚°ã‚’ S3ã«ä¿å˜ã—ã¾ã™ ä¿å˜å½¢å¼ã¯ GZIP ä»–ã¯ãƒ‡ãƒ•ã‚©ãƒ«ãƒˆã®è¨å®š ã€ä»Šå›žã®è¨˜äº‹å†…å®¹ã€‘Athenaã§ S3ã«å¯¾ã—ã¦ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œã€çµæžœã‚’ç¢ºèªãƒ»åˆ†æžã—ã¾ã™ Athenaã§S3ã«å¯¾ã—ã¦ã‚¯ã‚¨ãƒªã‚’å®Ÿè¡Œ ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆ ä¸‹è¨˜SQLã‚’ Athenaã® New query å…¥åŠ›æ¬„ã«è²¼ã‚Šä»˜ã‘ã¦ Run
mapk0y 2021/09/13
Athena

AWS
ãƒªãƒ³ã‚¯
Use parameterized queries - Amazon Athena
mapk0y 2021/08/16
ã‚ã¨ã§èªã‚€

Athena
ãƒªãƒ³ã‚¯
Cost optimization in AWS using Amazon CloudWatch metric streams, AWS Cost and Usage Reports and Amazon Athena | Amazon Web Services
AWS Cloud Operations Blog Cost optimization in AWS using Amazon CloudWatch metric streams, AWS Cost and Usage Reports and Amazon Athena You can use metric streams to create continuous, near-real-time streams of Amazon CloudWatch metrics to a destination of your choice. Metric streams make it easier to send CloudWatch metrics to popular third-party service providers using an Amazon Kinesis Data Fir
mapk0y 2021/07/27
ã‚ã¨ã§èªã‚€

AWS

Athena
ãƒªãƒ³ã‚¯
RDS_Auroraãƒ‘ãƒ•ã‚©ãƒ¼ãƒžãƒ³ã‚¹ã‚¤ãƒ³ã‚µã‚¤ãƒˆã®ãƒ‡ãƒ¼ã‚¿ã‚’Athenaã¨QuickSightã§è¦‹ã‚‹
JAWS-UG åå¤å±‹ ãƒ‡ãƒ¼ã‚¿åˆ†æžã‚’å¦ã¶ 2021/05/31
mapk0y 2021/06/01
Athena

Aurora

AWS
ãƒªãƒ³ã‚¯
About AWS
Since launching in 2006, Amazon Web Services has been providing industry-leading cloud capabilities and expertise that have helped customers transf orm industries, communities, and lives for the better. As part of Amazon, we strive to be Earthâ€™s most customer-centric company. We work backwards from our customersâ€™ probl ems to provide them with the broadest and deepest set of cloud and AI capabilitie
mapk0y 2021/04/12
AWS

Athena
ãƒªãƒ³ã‚¯
Athena+Embulk+BigQueryã«ã‚ˆã‚‹ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒã‚°ã®åˆ†æžç’°å¢ƒæ§‹ç¯‰
ã¯ã˜ã‚ã«ã“ã‚“ã«ã¡ã¯ã€Finatextã§è¨¼åˆ¸ãƒ—ãƒ©ãƒƒãƒˆãƒ•ã‚©ãƒ¼ãƒ ï¼ˆBrokerage as a Serviceã€ä»¥ä¸‹BaaSï¼‰ã®é–‹ç™ºã«æºã‚ã£ã¦ã„ã‚‹çŸ³æ©‹ï¼ˆ@bashi0501ï¼‰ã§ã™ã€‚éŽåŽ»ã®Finatextãƒ†ãƒƒã‚¯ãƒ–ãƒã‚°ã§ã¯Terraformã€CDKã¨IaCã‚’ãƒ†ãƒ¼ãƒžã«ã—ãŸè¨˜äº‹ã—ã‹æ›¸ã„ãŸã“ã¨ãŒãªã‹ã£ãŸã®ã§ã™ãŒã€ä»Šå›žã¯ãƒã‚°ã®åˆ†æžæ´»ç”¨ã‚’ãƒ†ãƒ¼ãƒžã¨ã—ã¾ã™ã€‚ æ¦‚è¦å¼Šç¤¾ã®è¨¼åˆ¸äº‹æ¥ã§ã¯ECSã«ã‚ˆã‚‹ãƒ¯ãƒ¼ã‚¯ãƒãƒ¼ãƒ‰ã‚’çµ„ã‚“ã§ã„ã¾ã™ã€‚æœ¬ãƒ†ãƒ¼ãƒžã®ã‚¢ãƒ—ãƒªã‚±ãƒ¼ã‚·ãƒ§ãƒ³ãƒã‚°ã«ã¤ã„ã¦ã¯æ¨™æº–å‡ºåŠ›ã—ãŸã‚‚ã®ã‚’aws logsãƒã‚°ãƒ‰ãƒ©ã‚¤ãƒãƒ¼ãŒå›žåŽã—ã¦CloudWatch Logsã«é€ä¿¡ã—ã¦ã„ã¾ã™ã€‚ ãƒã‚°ã®æ¤œç´¢ã¨ã„ã†è¦³ç‚¹ã§ã¯CloudWatch Logs Insightsã¨ã„ã†ã‚µãƒ¼ãƒ“ã‚¹ã§ã‹ãªã‚Šãƒªãƒƒãƒã«ãƒ•ã‚£ãƒ«ã‚¿ãƒ¼ã‚„é›†è¨ˆã‚’è¡Œã†ã“ã¨ãŒã§ãã‚‹ã®ã§ã™ãŒã€ãƒã‚°ãƒ‡ãƒ¼ã‚¿ã‚’å…ƒã«ã—ãŸãƒ¦ãƒ¼ã‚¶ãƒ¼ã®ãƒ•ã‚¡ãƒãƒ«åˆ†æžã‚„æ¥å‹™æ”¹å–„ï¼ˆå¾Œè¿°ã—ã¾ã™ï¼‰ã«æ´»ã‹ã—ã¦ã„ããŸã„ã¨ã„ã†æ„å›³ãŒã‚ã‚‹ãŸã‚ã€ãƒž
mapk0y 2021/03/18
embulk

Athena

bigquery
ãƒªãƒ³ã‚¯
Use Athena Workgroups to Separate Workloads Between Users or Applications, View Query Metrics, and Enforce Cost Controls - AWS
Use Athena Workgroups to Separate Workloads Between Users or Applications, View Query Metrics, and Enforce Cost Controls You can now use Amazon Athena Workgroups - A new resource type that can be used to separate query execution and query history between Users, Teams, or Applications running under the same AWS account. Because Workgroups act as resources, you can use resource-based policies to con
mapk0y 2019/03/07
Athena

AWS
ãƒªãƒ³ã‚¯
Very cool ã‚‰ã—ã„ AthenaCLI ã‚’è©¦ã—ã¦ã¿ãŸã‚‰ã€ã‚„ã£ã±ã‚Šã‚¯ãƒ¼ãƒ«ã ã£ãŸä»¶ | DevelopersIO
ã¯ã˜ã‚ã« Very cool ã‚‰ã—ã„ AthenaCLI ã‚’è¦‹ã¤ã‘ã¦ã—ã¾ã£ãŸã®ã§ã€æ—©é€Ÿè©¦ã—ã¦ã¿ãŸã„ã¨æ€ã„ã¾ã™ã€‚ Very cool: AthenaCLI - Command line interface to Amazon Athena - https://t.co/YAlghX2Upo (found on Awesome AWS - https://t.co/GaoWeC9Ntq) pic.twitter.com/abA2J8eMaO â€” Jeff Barr â˜ï¸ (@jeffbarr) October 18, 2018 å°Žå…¥ ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ« ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ãŸç’°å¢ƒã¯ã€macOS High Sierra / ãƒãƒ¼ã‚¸ãƒ§ãƒ³10.13.6ã€python3.6ã§ã™ã€‚dbcli/athenacliã«æ›¸ã„ã¦ã‚ã‚‹ã¨ãŠã‚Šã€pipã§ã‚¤ãƒ³ã‚¹ãƒˆãƒ¼ãƒ«ã—ã¾ã™ã€‚ $ pip install athenacli Coll
mapk0y 2018/10/19
Athena

AWS
ãƒªãƒ³ã‚¯
Amazon Athena adds support for Creating Tables using the results of a Select query (CTAS)
Since launching in 2006, Amazon Web Services has been providing industry-leading cloud capabilities and expertise that have helped customers transf orm industries, communities, and lives for the better. As part of Amazon, we strive to be Earthâ€™s most customer-centric company. We work backwards from our customersâ€™ probl ems to provide them with the broadest and deepest set of cloud and AI capabilitie
mapk0y 2018/10/16
Athena
ãƒªãƒ³ã‚¯
AWS WAFã®ãƒ•ãƒ«ãƒã‚°ã‚’Athenaã§åˆ†æžã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã¿ãŸ | DevelopersIO
ã“ã‚“ã«ã¡ã¯ã€è‡¼ç”°ã§ã™ã€‚ çš†ã•ã‚“ã€WAFWAFã—ã¦ã¾ã™ã‹ï¼Ÿ(æ€ã„ã¤ã ã¤ã„ã«AWS WAFã§ãƒ•ãƒ«ãƒã‚°ã‚’å–å¾—ã™ã‚‹ã“ã¨ãŒã§ãã‚‹ã‚ˆã†ã«ãªã‚Šã¾ã—ãŸï¼ã™ã£ã”ã„ã‚ãã‚ãã—ã¦ã¾ã™ã€‚ AWS WAFã®ãƒã‚°ã‚’Firehoseã§S3ã«å‡ºåŠ›ã—ãƒ–ãƒãƒƒã‚¯ãƒã‚°ã‚’S3Selectã§ç¢ºèªã—ã¦ã¿ãŸ ã“ã‚Œã¾ã§ã¯é ‘å¼µã£ã¦sampleãƒã‚°ã‚’å–å¾—ã—ã¦ã‚´ãƒ‹ãƒ§ã‚´ãƒ‹ãƒ§ã—ã¦ã„ã¾ã—ãŸãŒã€ã“ã‚Œã‹ã‚‰ã¯Kinesis Data Firehoseã«ã¤ã£ã“ã‚“ã§ã‚„ã‚ŠãŸã„æ”¾é¡Œã§ã™ï¼ ä»Šå›žã¯ã¨ã‚Šã‚ãˆãšãã®ã¾ã¾S3ã«åãå‡ºã•ã‚ŒãŸãƒã‚°ã‚’Athenaã§åˆ†æžã§ãã‚‹ã‚ˆã†ã«ã—ã¦ã¿ã¾ã™ã€‚ ãƒã‚°ã‚’S3ã«å…¥ã‚Œã‚‹ã¨ã“ã‚ã¾ã§ã®æ–¹æ³•ã¯ä¸Šè¨˜è¨˜äº‹ã‚’å‚è€ƒã«ã—ã¦ãã ã•ã„ã€‚ ãƒ†ãƒ¼ãƒ–ãƒ«ä½œæˆ ãƒã‚°ã®ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã¯ã“ã¡ã‚‰ã«ã‚ã‚Šã¾ã™ã€‚ CREATE TABLEã¯ä¸‹è¨˜ã®ã‚ˆã†ã«ãªã‚Šã¾ã™ã€‚ 2020/01/05è¿½è¨˜ XSS/SQLiãƒžãƒƒãƒãƒ«ãƒ¼ãƒ«è©³ç´°è¿½åŠ ã«ã‚ˆã‚‹ã‚¹ã‚ãƒ¼ãƒžå¤‰æ›´ã‚’åæ˜ ã—ã¾ã—ãŸ 2018/12/24
mapk0y 2018/09/02
Athena

AWS
ãƒªãƒ³ã‚¯
Amazon Athena RegexSerDe ã‚’åˆ©ç”¨ã—ã¦ ALB ãƒã‚°ã‚’æŽ¢ç´¢ã™ã‚‹(2018å¹´8æœˆç‰ˆ) | DevelopersIO
ã¯ã˜ã‚ã« ä»Šå›žã¯ALBãƒã‚°ã®æœ€æ–°ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆã«å¯¾å¿œã—ãŸæŽ¢ç´¢æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ä¸€å¹´å‰ã«Amazon Athena RegexSerDe ã‚’åˆ©ç”¨ã—ã¦ ALB ãƒã‚°ã‚’æŽ¢ç´¢ã™ã‚‹ã¨ã„ã†ãƒ–ãƒã‚°ã§ALB ãƒã‚°ã‚’æŽ¢ç´¢ã™ã‚‹æ–¹æ³•ã‚’ç´¹ä»‹ã—ã¾ã—ãŸãŒã€æœ€æ–°ã®ALB ãƒã‚°ãŒæŽ¢ç´¢ã§ããªã„ã¨ã„ã†å ±å‘Šã‚’å—ã‘ã¾ã—ãŸã€‚ç¢ºèªã—ãŸã¨ã“ã‚ãƒã‚°ãƒ•ã‚©ãƒ¼ãƒžãƒƒãƒˆæœ€å¾Œã«ä»¥ä¸‹ã®6é …ç›®è¿½åŠ ã•ã‚Œã¦ã„ã¾ã—ãŸã€‚ domain_name chosen_cert_arn matched_rule_priority request_creation_time actions_executed redirect_url åŸ·ç†æ™‚ç‚¹ã§ã¯ã€è¿½åŠ ã•ã‚ŒãŸãƒ•ã‚£ãƒ¼ãƒ«ãƒ‰ã®æƒ…å ±ã¯ã€ä»¥ä¸‹ã®è‹±èªžãƒžãƒ‹ãƒ¥ã‚¢ãƒ«ã«ã®ã¿ã®è¨˜è¼‰ã¨ãªã‚Šã¾ã™ã®ã§ã”æ³¨æ„ãã ã•ã„ã€‚ Access Logs for Your Application Load Balancer - Access Log Entries
mapk0y 2018/08/27
ALB

Athena
ãƒªãƒ³ã‚¯
S3ã«ãƒ•ãƒ©ãƒƒãƒˆã«é…ç½®ã—ã¦ã—ã¾ã£ãŸãƒã‚°ã‚‚å¤§ä¸ˆå¤«ï¼ã‚·ãƒ³ãƒœãƒªãƒƒã‚¯ãƒªãƒ³ã‚¯ã‚’åˆ©ç”¨ã—ã¦ã‚¹ã‚ãƒ£ãƒ³ç¯„å›²ã‚’çµžã£ã¦Athenaã‹ã‚‰ã‚¯ã‚¨ãƒªã™ã‚‹ | DevelopersIO
mapk0y 2018/06/17
Athena

AWS
ãƒªãƒ³ã‚¯
S3ãƒã‚±ãƒƒãƒˆå†…ã®ãƒ•ã‚¡ã‚¤ãƒ«ä¸€è¦§(S3 Inventory)ã‚’Athenaã‚’åˆ©ç”¨ã—ã¦åˆ†æžã™ã‚‹ | DevelopersIO
æ•°åƒä¸‡å˜ä½ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’é…ç½®ã—ãŸS3ãƒã‚±ãƒƒãƒˆå†…ã«ã€ç‰¹å®šã®æ‹¡å¼µåã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŒä½•ç‚¹å˜åœ¨ã™ã‚‹ã‹ã‚’ç°¡å˜ã«ç¢ºèªã™ã‚‹æ–¹æ³•ãŒãªã„ã‹èª¿ã¹ã‚‹æ©Ÿä¼šãŒã‚ã‚Šã€S3 Inventoryæ©Ÿèƒ½ã‚’åˆ©ç”¨ã—ã¦ãƒ•ã‚¡ã‚¤ãƒ«ä¸€è¦§ã‚’å–å¾—ã—ã€ãã®çµæžœã‚’Athenaã‚’åˆ©ç”¨ã—ã¦è§£æžã—ã¦ã¿ãŸã®ã§ã€ãã®æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ è¥¿æ¾¤ã§ã™ã€‚ãŠå®¢æ§˜ã‚ˆã‚ŠãŠå•ã„åˆã‚ã›ã‚’ã„ãŸã ãã€æ•°åƒä¸‡å˜ä½ã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆã‚’é…ç½®ã—ãŸS3ãƒã‚±ãƒƒãƒˆå†…ã«ã€ç‰¹å®šã®æ‹¡å¼µåã®ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆãŒä½•ç‚¹å˜åœ¨ã™ã‚‹ã‹ã‚’ç°¡å˜ã«ç¢ºèªã™ã‚‹æ–¹æ³•ãŒãªã„ã‹èª¿ã¹ã‚‹æ©Ÿä¼šãŒã‚ã‚Šã¾ã—ãŸã€‚aws s3 lsã®çµæžœã‚’grepã™ã‚‹ã£ã¦ã„ã†æ°—ã®é ããªã‚‹ã‚ˆã†ãªæ–¹æ³•ã¯ç¾å®Ÿçš„ã§ã¯ãªã„ã‚ªãƒ–ã‚¸ã‚§ã‚¯ãƒˆæ•°ã ã£ãŸç‚ºã€S3 Inventoryæ©Ÿèƒ½ã‚’åˆ©ç”¨ã—ã¦ãƒ•ã‚¡ã‚¤ãƒ«ä¸€è¦§ã‚’å–å¾—ã—ã€ãã®çµæžœã‚’Athenaã‚’åˆ©ç”¨ã—ã¦è§£æžã—ã¦ã¿ã‚‹ã“ã¨ã«ã—ã¾ã—ãŸã®ã§ã€ãã®æ–¹æ³•ã‚’ã”ç´¹ä»‹ã—ã¾ã™ã€‚ ã€æ–°æ©Ÿèƒ½ã€‘S3 Inventoryã‚’è©¦ã—ã¦ã¿ãŸ #reinvent ï½œ De
mapk0y 2018/06/17
s3

Athena
ãƒªãƒ³ã‚¯
1 2 æ¬¡ã®ãƒšãƒ¼ã‚¸