We have successfully implemented persistence schedules and have views and table written to postgres. This may be a stupid question but if we are using postgres for visualizations (dashboards), does holistics automatically use those tables in queries or is there something additional we need to do. If so, how do you reference those tables in the a query?
Hi Chuck,
Thank you for your question.
Yes, Holistics will automatically use the persisted tables, if available, in place of the original model queries. You could double-check the final generated query in the Executed SQL panel or in Job Logs.
We have this documentation that describes the aforementioned behavior:
Though I guess we could make it clearer about the details you are asking for.
Let me know if you have any further questions!
I can see that. Do you know if there is a way to set up full persistence and incremental persistence for the same query model. The use case is would be running full persistence at night or once a week and incremental persistence at certain times between those full updates. We need this to remove deleted records.
Hi Chuck,
That’s a good idea. I can see how setting up incremental persistence in between the full persistence schedules would be useful here.
Unfortunately, at the moment there isn’t a way to set up 2 different persistence modes for the same query model. We’ve taken notes for future enhancements.
May I ask if you’re comfortable with setting up only full persistence for this case for now?