Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
cancel
Showing results for 
Search instead for 
Did you mean: 
Qlik_Wizard
Contributor II
Contributor II

Automation to delete QVDs older than n number of days

Hi everyone, is there any way to build an automation that will delete qvds older than n number of days? I am open to any other alternatives also!

Thanks!!

Labels (4)
7 Replies
Qlik_Wizard
Contributor II
Contributor II
Author

Hi, Thanks for replying! I want to set up an automation in qlik SaaS, to delete qvds older than 10+ days

David_Friend
Support
Support

I'm watching this video:

https://www.youtube.com/watch?v=jzcZfCBQsMk

its a bit hard to follow, but may help you

Qlik_Wizard
Contributor II
Contributor II
Author

Hi, Thanks for replying! This youtube video is just to create an automation to delete qvds, but I'm in search of an automation or any other alternative to delete the qvds older than the defined number of days. (older than 10 days to be exact)

Daniel_Pilla
Employee
Employee

Hi @Qlik_Wizard ,

Please see the attached. Just fill in the variable with the number of days back and it will delete any QVD that was created older than that many days ago. I will go on the record and say that this is not a great idea IMO as there are plenty of reasons you may have archival QVDs, or QVDs that are still being used but haven't been updated in a while. 10 days seems wildly tight 🙂

 

You might want to check out a number of OOTB automations such as "Alert app owners about apps without reloads in the past X days." These automation templates notify the users directly and look to have them clean things up at their own discretion.

 

I hope this helps!

Qlik_Wizard
Contributor II
Contributor II
Author

Hey thanks for responding! Can you please guide me on how to use this? I mean what am i supposed to do with this json file? Sorry if this a dumb question.

Daniel_Pilla
Employee
Employee

Hey @Qlik_Wizard ,

Create a new blank automation. Right-click on the canvas and select "Upload workspace". Navigate to the JSON file and select it. That's it! Then just fill in the "DaysBack" variable. I would highly suggest testing first to make sure it is capturing the files you'd like. You can temporarily disable the "Delete Data File" block by right-clicking it as well.

Cheers,