Hi Team, have this requirement to purge data accor...
# general
s
Hi Team, have this requirement to purge data according to brand id (a column inside a table) . How can I go about this? Do I create tenants and table for each brand id?
m
how many brands do you have?
I’m wondering if you could key your stream by brand id and then you could purge segments by name (the prefix of segments is their partition id). I dunno if that’s a good idea though so I’ll cc @Mayank to give his thoughts too
s
There can be 100s of brands.
@Mark Needham @Mayank Right now I have around 200+ brands and may add 1000 more in future. Will creating partions for each brand be feasible?
m
You can use segment purge minion job. Might have to hook it up to specify what brand id to purge