I have a customer with a use case where they would like to archive everything older than 1 year to a different storage location. Do they have to update the storage location policy periodically to move the range, or can they set a function like CURRRENT_DATE - INTERVAL '1 YEAR'?
Also, if storage policies overlap, is there a precedence order to resolve where data lands? Or is there something preventing overlap?
Question
Dynamic storage policies, or updating storage policies
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.