Caching Policy on PDT

Looker Q&A Looker
1

Can you create a caching policy on a PDT to be something like “at 06:00 every day”, rather than persisting for 24 hours?

2

Hello,

Yes, you can definitely do that.

Using a trigger like this (Snowflake), it will rebuild PDT at 4AM UTC:

SELECT FLOOR((DATE_PART(‘EPOCH_SECOND’, CURRENT_TIMESTAMP) - 60604)/(606024))

Have a nice day!
Antho