AWS › AWS CloudTrail & Auditing
How does CloudTrail Lake differ from traditional CloudTrail trails for running complex audit queries?
AdvancedAnswer
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.