Nested Queries with CloudTrail Lake

Question

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

```
select data.*
from (
   select * from EDS limit 10
) as data
```

Answer

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  where eventName in (select distinct (eventName) from where eventName='CopyObject') and 
(eventTime > date_add('day',-1, now()))
```

Nested Queries with CloudTrail Lake

Contenuto pertinente