docs/thoughtspot_quality_reporting_source.md

# ThoughtSpot Quality Reporting Source

The DemoPrep quality reporting liveboard is:

- URL: `https://se-thoughtspot-cloud.thoughtspot.cloud/#/pinboard/85ccf9c9-2487-40b6-9f97-f9cf5207436b`
- Liveboard name: `demoprep testing`
- ThoughtSpot model: `demoprep_test_data`
- Model GUID: `db310fd7-b382-49d2-8398-b2f378d179f6`
- Physical table: Postgres `public.ts_quality_results`
- ThoughtSpot table GUID: `c12ee8a3-2b5d-4597-a873-eddb9ffaddc5`

Important: this reporting liveboard does **not** read from `session_logs`.
`session_logs` is useful for pipeline-stage diagnostics and run lineage, but deleting
bad rows from `session_logs` will not remove them from the quality reporting charts.

The liveboard's score charts use `ts_quality_results`, including:

- `Weekly Average Score Trend`: `average [Total Score] [Run Timestamp].weekly`
- `Weekly Average Data Score Trend`: `average [Data Score] [Run Timestamp].weekly`
- `Daily Data Score Trend`: `average [Data Score] [Run Timestamp].daily [Run Timestamp] = 'last 3 weeks'`

Cleanup workflow:

1. Inspect the liveboard TML if the source is uncertain.
2. Query `ts_quality_results` for the affected date window.
3. Delete or filter rows in `ts_quality_results`, not only `session_logs`, when the
   reporting liveboard needs to change.
4. Use `session_logs` only to validate run provenance, user, stage completion, and
   failure causes.