One-off dotcom DB query: connect environments with resource groups
Proposal
As we want to better understand resource group usage, a topic that came up is the relationship between environments and resource groups. Some related questions:
- Are the majority of environments deployed with a resource group?
- Are resource groups used together with environments?
- Do environments deploy with a single or multiple resource groups?
Given dotcom data, we should be able to analyze these question.
Output
CSV files with deployments (deployable?) and resource group (processable?) data for the past 6 months that show environment and job ids. The actual analysis would happen outside of this issue.
Likely CSV headers:
- job id
- job last updated datetime
- deployment id
- deployment last updated datetime
- pipeline id
- environment id
- resource group id / name
- resource group process mode (optional)
- resource group last updated datetime
- project id (optional)
Note: the resource group id and datetime above refers to a resource group lock (processable?), not a resource group record
Edited by Viktor Nagy (GitLab)