Aggregate projections and partitions
I'm investigating the adoption of the aggregate projections to improve metrics on data having more or less dimensions, accordingly the dashboard is accessing them.
They seems to be the right tool for this case but they also are deprecated in case of updates and deletes.
Updates are not a concern, but I would like to ask you about deletes: such data is retained for a given period then dropped using a drop partition call.
Is there any affinity between a delete statement and the drop partition that could affect the adoption of the aggregate projections?
thank you in advance