Datagroup

[Prasanth-paikad]

In my existing project,i found that in datagroup they used both sql trigger and interval trigger 5 minutes,does it have any problem.in looker ltest documentation said that don't use both in datagroup.if admin side pdt and datagroup maintenence section they given 5 minutes.then why it required interval trigger.please suggest good cache policy for in this case.

[GavinW]

The docs tell us that if you have both, then Looker will ignore the sql_trigger as it consumes DB resources and interval_trigger does not.

It's not really possible to tell you what cache policy makes sense without a lot of information about your data and the use your users will be making of it. How fresh does it need to be? How expensive are the queries? What balance do you want to strike between query costs and the freshness of results? 

The answers to these questions should help you decide what kind of cache policy makes sense for this use case.