I have implemented some queries and dashboards where I used cloudwatch logInsight. I have used sample queries where I used parse, fields, aggregate functions etc.
I am curious if we need complex queries like joins, windows functions etc, can we use Loginsight query language to create our scenarios just as done in SQL? I didn't find any good examples on docs here: https://docs.aws.amazon.com/AmazonCloudWatch/latest/logs/CWL_QuerySyntax.html
Also I read Cloudwatch log are six times expensive as compare to aws athena.
Is there any suggestions on complex monitoring what is the best way to do monitoring in aws?
