Nested Queries with CloudTrail Lake

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

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

主题

分析管理与治理

标签

Amazon Athena 分析 AWS CloudTrail

语言

English

rjeffries

已提问 1 年前317 查看次数

1 回答

最新
投票最多
评论最多

这些答案有用吗？为正确答案投票，以帮助社区从您的知识中受益。

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()))

YagyaVir_S

已回答 1 年前

Nested Queries with CloudTrail Lake

相关内容