Question

Caching Policy on PDT

  • 4 July 2021
  • 1 reply
  • 15 views

Userlevel 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?


1 reply

Userlevel 3

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

 

Reply