Datagroup trigger is not functioning

Looker Q&A Looker
1

Hello Looker Support Team,

I hope this message finds you well.

I am currently facing an issue with my scheduled report delivery. I have a report set to be delivered every day at 03:30 PST. but the datagroup is stop triggerring and its not working for last 56 days.

The problem is that the datagroup from lookml is not triggering for last one month.

Could you please assist me in resolving this issue? Any help or guidance you can provide would be greatly appreciated.

datagroup: transaction_summary_datagroup{
description: “”
max_cache_age: “24 hours”
sql_trigger: SELECT count(*) FROM Table
where Instance_Name=‘XYZ’ and Average_time>0.3;;
}

Thank you in advance for your support.

2

Hi there - just to call out, this isn’t a way to reach Looker support, this is just the Looker Community site where users can share information and support each other!

Having said that, the first thing to do is check whether your datagroup trigger query is actually working. Can you run the trigger query in SQL runner against the database and see what results you get? A datagroup will only trigger when the results of that query change, so if it keeps returning nothing, an error, or the same number every time, then your datagroup will remain untriggered indefinitely.