Can you create a caching policy on a PDT to be something like “at 06:00 every day”, rather than persisting for 24 hours?
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