SaaS: Missing subscription_id <> namespace_id mapping
There are currently two tables in GitLab.com postgres data that contains the subscription history for our customers, specifically the mapping of a namespace_id to a subscription_id:
- gitlab_subscriptions
- gitlab_subscriptions_histories (2019-12-11 20:18:36.592 is the earliest timestamp)
One reason the histories table was created was to capture the historical data but we are missing time periods and we must ensure that the namespace_id to a subscription_id is always retained for the given time period of association.
We need this to be able to properly segment all product metrics by paid plan - for example SaaS split by paid/free. https://about.gitlab.com/handbook/product/stage-and-group-performance-indicators/
the SaaS ARR impact of this issue can be found in this chart
Edited by Kathleen Tam