I’m trying to determine how close our lambda invocations are to their pre-set timeout. The goal is to create a query that I can use in an alert condition.
I can clearly see that the data I need is available on the AwsLambdaInvocation record as both duration and provider.timeout are there. However, any attempt at using a math function with provider.timeout fails. I’ve tried using numeric() in case the value is actually a string, but that also doesn’t work.
Here’s an example of some NRQL that should get what I want, but the ‘Percentage of Timeout’ will always be null.
SELECT duration, provider.timeout, duration/provider.timeout*100 as ‘Percentage of Timeout’ FROM AwsLambdaInvocation SINCE 1 Week Ago
Thanks for your help.