AWS › AWS CloudTrail & Auditing

How does CloudTrail Lake differ from traditional CloudTrail trails for running complex audit queries?

Advanced

Answer

CloudTrail Lake is a managed data lake specifically for CloudTrail events that lets you run SQL based queries directly against your audit logs without needing to first set up a separate system like Athena and manage the underlying S3 data structure yourself, making it easier to perform complex, ad hoc investigations and generate compliance reports directly from a purpose built interface designed specifically for security and audit analysis.
aws cloudtrail start-query --query-statement "SELECT eventName, COUNT(*) FROM my_event_data_store GROUP BY eventName ORDER BY COUNT(*) DESC"
Real-world example A compliance team uses CloudTrail Lake to quickly run an ad hoc SQL query identifying every instance where a specific sensitive IAM policy was modified over the past year, without needing to set up a custom Athena table structure themselves.

Common follow-ups: How does CloudTrail Lake pricing compare to querying CloudTrail logs manually through Athena?;How long can event data stores in CloudTrail Lake retain data?