In Holistics 4.0 there is new way to create persistent models but I can’t find a way to make it work.
I used this page for help : Persistence Query Model | Holistics Docs
Thanks it worked !
But there may be an issue with the retention policy of persistent models. Apparently Holistics creates a new table everytime it refreshes a persistent model but it does not appear to delete older tables.
Is it normal ?
Alright, understood. Even old versions of a persisted table are kept for 24 hours.
So we should not schedule refreshes too often otherwise the size of the database will get out of control. Do you plan to give us more control on that retention delay ?
For now, we don’t have a plan to make the persisted_table’s invalidation controllable @dacou.
However, we totally understand that your schema might be messy if you’re unable to control the persistence invalidation opearation. I will note this down and improve it in the future