-
Leaminn Ma authored
Adds a new partitioned table p_catalog_resource_component_usages. This table will track when a CI component is included in a project's pipeline. Only unique records of component-used_by_project-used_date are inserted. This data will be used to display component usage popularity aggregated by component or catalog_resource per 30 day rolling window. This table is partitioned by month. For now, the table will drop partitions with data older than 12 months. This duration will likely be reduced in a follow up issue. Changelog: added