[DevOps Adoption] Modify queries for CI table decomposition
Problem to solve
For SaaS, CI tables are being moved to a separate database. This is to improve performance through "decomposition". After that, queries that JOIN on CI tables will no longer function.
Some DevOps Adoption data refresh queries rely on CI tables:
-
ci_builds
forsecurity scan
metric -
ci_runners
forrunner configured
metric -
ci_pipelines
forpipeline_succeeded
metric -
ci_job_artifacts
forsast
,dast
,coverage fuzzing
,dependency scanning
metrics
Some of them might use JOIN
out of ci_*
tables
Proposal
Ensure that all DevOps Adoption queries will continue to function after CI table decomposition.
Related links