Closed Bug 1879874 Opened 2 years ago Closed 2 years ago

Data Platform Check dashboard error querying the related Bug

Categories

(Data Platform and Tools :: Monitoring & Alerting, defect)

Product:
Data Platform and Tools
Component:
Monitoring & Alerting
Type:
defect

Tracking

(Not tracked)

Status:
RESOLVED WONTFIX

People

(Reporter: lvargas, Unassigned)

Details

Dashboard
https://mozilla.cloud.looker.com/explore/monitoring/schema_error_counts?qid=IDldvAQKGqBdenKmpZ2Hp5&origin_space=511&toggle=vis

Error:
The Google BigQuery Standard SQL database encountered an error while running this query.
Query execution failed: - Array index 1 is out of bounds (overflow)

This is querying OFFSET[1] which falls out of range:

    WHEN schema_errors_notes.bug IS NOT null THEN CONCAT("Bug ", SPLIT(schema_errors_notes.bug, "=")[OFFSET(0)])
        ELSE ""
      END
       AS schema_errors_notes_bug_link

It needs to be OFFSET[0] OR a SAFE_OFFSET.

Summary: Data Paltform Check dashboard error querying the related Bug → Data Platform Check dashboard error querying the related Bug

The Dashboard expects a link in column Bug in the source spreadsheet sheet Schema Errors. It broke when adding other data (TBD, TBC)

Status: NEW → RESOLVED
Closed: 2 years ago
Resolution: --- → WONTFIX
You need to log in before you can comment on or make changes to this bug.