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
已提問 1 年前檢視次數 317 次
1 個回答
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
已回答 1 年前

您尚未登入。 登入 去張貼答案。

一個好的回答可以清楚地回答問題並提供建設性的意見回饋,同時有助於提問者的專業成長。

回答問題指南