Overview

The process of gathering the data for Sources is very simple: basically a query runs on the 1st of every month via AppInterface, and the results are yielded on a pod. Then, by accessing the logs of that pod, we are able to access the results, which then need to be written on the Excel document.

Specifics

1. The /data/app-interface/sql-queries/insights/sources/prod-insights-sources-monthly-data-status-report.yaml runs on the 1st of every month.
2. Log in to Insights Prod's cluster.
3. Issue an oc logs -f <pod-name> command to get the results. Or redirect the results to a file to read them easily with oc logs -f <pod-name> > /tmp/report-results.txt.
4. Update the spreadsheet.

I missed the date!

If you missed the date for a query, you can always copy and paste the query file, change the name of the query, remove the schedule part and wait for AppSre to merge the MR. That will allow you to see the results for a particular day.