Hello Team! We have a pinot cluster with a table that has data for around 1k customers ranging in size from very small to very large. We have a tenant_name field that distinguishes the customer as they query. We have a 90 day retention by default but we have a few customers who would like more retention. We are considering creating separate tables for these large customers so we can tweak their retention setting to what they want. Has anyone else implemented something like this to handle different customer needs for the same table/schema?
m
Mayank
03/18/2025, 1:42 PM
Yes, using different tables, or tenants that share same properties is one way. One enhancement could be partition specific retention (could also help with gdpr purge), but doesn’t exist today