When creating a NRQL alert condition, the preview chart shows the message “We ran into an error while trying to return your chart data.” for the follow query that seems to work ok in Insights:
SELECT max(provider.numberOfMessagesSent.Sum) FROM QueueSample WHERE provider.queueArn = 'arn:aws:sqs:us-east-1:906683028152:QE_Carvim_DLQ'
I can save the alert condition, but I have no idea if it’s actually working. I interpret the error message that there something wrong with my query. Do NRQL alert conditions support QueueSample events coming from my AWS SQS environment?
NRQL alert condition:
https://alerts.newrelic.com/accounts/2152850/policies/481486/conditions/10849245/edit?selectedField=thresholds
Insights dashboard with the same query:
https://insights.newrelic.com/accounts/2152850/dashboards/957511