36.8 CloudTrail Lake: Querying CloudTrail Events with SQL
Right, so you’ve got your CloudTrail logs flowing into a Lake. Congratulations, you’ve successfully moved your digital haystack from one barn (S3) to a slightly more organized barn (Lake). But now what? You’re staring at petabytes of JSON blobs thinking, “There has to be a a better way to find this one specific API call than grep.” There is. It’s called SQL, and CloudTrail Lake’s query feature is your new best friend. It lets you interrogate that mountain of audit data without having to load it into another service or, heaven forbid, download it. Let’s cut through the marketing fluff and get to how it actually works.