License model does not use the creator_id column
Problem
We recently found out by way of this thread, https://gitlab.com/gitlab-data/analytics/-/issues/13856#note_1071008242, that the creator_id
column in the licenses
table is not being used. I thought this table was used to store the id of the Admin responsible for creating a License manually, but as it turns out, this informatino is actually retrieved from the license_versions
table (used by PaperTrail for auditing).
I found this MR, https://gitlab.com/gitlab-org/customers-gitlab-com/-/merge_requests/3153, where this strategy was implemented and suggested we follow-up to determine what to do with creator_id
given it wasn't being used.
If we decide to remove this column from the licenses
table in CDot, we need to make sure the referenced field in Snowflake is removed first to avoid any errors the Data team might encounter. Let's first check with @iweeks
to ensure the referenced fields have been removed before proceeding. Once we get the green light from the Data team, we can change this from workflowblocked to workflowready for development.
Proposal
Let's decide whether it's useful to keep this creator_id
column. If it isn't, let's remove any references in code and drop it.