By using AWS re:Post, you agree to the AWS re:Post Terms of Use
AWS re:Postre:Post
About re:Post

Nested Queries with CloudTrail Lake

1

Does anyone know if it's possible to nest queries specifically with CloudTrail Lake?

select data.*
from (
   select * from EDS limit 10
) as data
Topics
AnalyticsManagement & Governance
Tags
Amazon AthenaAnalyticsAWS CloudTrail
Language
English
rjeffries
asked 2 years ago516 views
1 Answer
0

Hello, Nested queries are supported now. Please refer to this launch announcement. https://aws.amazon.com/about-aws/whats-new/2023/05/aws-cloudtrail-lake-query-presto-sql-select-functions/

Below is sample nested query for your reference. Hope this helps and please reach out if you have any questions.

select * from <EDS DETAILS> where eventName in (select distinct (eventName) from <EDS DETAILS>where eventName='CopyObject') and 
(eventTime > date_add('day',-1, now()))
AWS
EXPERT
YagyaVir_S
answered 2 years ago

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions

Relevant content