Allow deleting group types

[macobo]

Is your feature request related to a problem?

We limit the number of available group types to 5 and they are currently undeletable.

Describe the solution you'd like

This is made tricky by:

1. Deletions being expensive in clickhouse
2. How we implemented groups in an efficient manner.

A workaround for this is to:

1. Add a min_timestamp field to group type mapping table
2. When filtering (or aggregating) by some group type, use timestamp from (1) to exclude old (deleted) data from query

Describe alternatives you've considered

Continue suggesting the manual approach:

1. Stop sending data for group type
2. Remove entry in group_type_mapping table
3. (Optional) Purge data in clickhouse.

Additional context

Thank you for your feature request – we love each and every one!

[Vadorequest]

I have a similar issue, where I misconfigured some projects and I don't know how to delete misconfigurated group types.

[alexkim205]

More context - https://posthoghelp.zendesk.com/agent/tickets/1383

[Twixes]

+1 from ZEN-2848

[Twixes]

+1 from ZEN-3412

[tiina303]

Internal docs for how to delete group types: go/rb/ingestion/groups

[Vadorequest]

@tiina303 Your link is wrong or dead.

[tiina303]

I just documented "Remove entry in group_type_mapping table" for our internal use - how to access the right place, that's an internal link.

[MarconLP]

+1 from https://posthoghelp.zendesk.com/agent/tickets/5117

[MarconLP]

+1 from https://posthoghelp.zendesk.com/agent/tickets/5152

[xvello]

+1 from https://posthoghelp.zendesk.com/agent/tickets/7815

[mathieubellon]

I also +1 for any way to delete/hide groups.

The group feature is a time savvier, but the inability to fix our mistakes or change of heart is really weird in an overall, UX wise, well thought product

Should I vote somewhere ?