Solved: How often will the cache be cleared by this data g... - Page 2

honghai_sg99-16 · 08-08-2022 07:48 PM

If I have a datagroup with a sql_trigger of ‘SELECT CURRENT_TIMESTAMP" (that is, it selects the
current date, hour, minute, and second), then how often will the cache be cleared by this datagroup?

Dawid

Based on the information in the documentation: https://docs.looker.com/reference/model-params/datagroup#sql_trigger I would say that it would run cache every time (or every second) because the value returned will be different each time.

For PostgreSQL, for example the value of CURRENT_TIMESTAMP is:

2022-08-09 11:16:56.715328 +00:00

which means unless I have two queries in a microsecond, I wouldn’t hit the cache

View solution in original post

How often will the cache be cleared by this data group which using sql_trigger?