AWS Certified Security Specialist Podcast

1.3.10 Querying logs in Amazon S3 for contextual information related to security events (for example, by using Athena)

18 Sep 2025

Audio

Description

1.3.10 Querying logs in Amazon S3 for contextual information related to security events for example, by using Athena - Querying logs in Amazon S3 using Amazon Athena is a key skill for AWS engineers investigating security events and incidents. Athena allows users to run SQL queries on large volumes of log data stored in S3such as CloudTrail and VPC Flow Logswithout the need to manage infrastructure, making it ideal for scalable and fast security analysis. Engineers must understand AWS log formats, configure Athena tables with optimized schemas and partitions, and write advanced SQL queries to extract actionable insights, reconstruct incident timelines, and correlate data across multiple sources. Best practices include optimizing performance through partitioning and data compression, automating query execution using Lambda and EventBridge, and securely managing access with IAM policies and S3 encryption. Integrating Athena queries with AWS security services like GuardDuty, Security Hub, and Amazon Detective enhances investigation workflows and validates findings. Mastering these skills not only accelerates incident response but also improves an organizations overall security and compliance posturemaking them essential for both real-world AWS environments and the AWS Certified Security - Specialty exam.

Transcription

This episode hasn't been transcribed yet

Help us prioritize this episode for transcription by upvoting it.

0 upvotes

🗳️ Sign in to Upvote

Popular episodes get transcribed faster

Other recent transcribed episodes

Transcribed and ready to explore now

3ª PARTE | 17 DIC 2025 | EL PARTIDAZO DE COPE

01 Jan 1970

El Partidazo de COPE

13:00H | 21 DIC 2025 | Fin de Semana

01 Jan 1970

Fin de Semana

12:00H | 21 DIC 2025 | Fin de Semana

01 Jan 1970

Fin de Semana

10:00H | 21 DIC 2025 | Fin de Semana

01 Jan 1970

Fin de Semana

13:00H | 20 DIC 2025 | Fin de Semana

01 Jan 1970

Fin de Semana

12:00H | 20 DIC 2025 | Fin de Semana

01 Jan 1970

Fin de Semana

Comments

There are no comments yet.

Please log in to write the first comment.

Report any issue

AWS Certified Security Specialist Podcast

1.3.10 Querying logs in Amazon S3 for contextual information related to security events (for example, by using Athena)

This episode hasn't been transcribed yet

Other recent transcribed episodes

3ª PARTE | 17 DIC 2025 | EL PARTIDAZO DE COPE

13:00H | 21 DIC 2025 | Fin de Semana

12:00H | 21 DIC 2025 | Fin de Semana

10:00H | 21 DIC 2025 | Fin de Semana

13:00H | 20 DIC 2025 | Fin de Semana

12:00H | 20 DIC 2025 | Fin de Semana

Sign in to Audioscrape

Share this moment