Would it be possible to split the table in two? The archive table would rebuild completely each night, with a live (derived) table pulling in only records updated in the current day. A subsequent derived_table could be written to pull only the latest...

just to add to an info, we could rebuilt the full PDT by adding a space to the query…. but couldn’t figure how to full rebuild a view that has incremental PDTs without doing a Pull request

I have an issue where i had a bug with my data source and i will need to rebuild the whole incremental PDT and not finding a way to do that without changing the query, push to production and changing it back and push to production again (which i will...