Caching Policy on PDT

[kuopaz]

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

[antho]

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) - 60*60*4)/(60*60*24))

Have a nice day!
Antho