1903788 - Airflow task bqetl_glean_usage.reference_browser.checks__warn_org_mozilla_reference_browser_derived__baseline_clients_last_seen__v1 is failing since exec_date 2024-06-20

Status: RESOLVED FIXED

(Data Platform and Tools :: General, defect)

Description

[Lucia Vargas]

Airflow task bqetl_glean_usage.reference_browser.checks__warn_org_mozilla_reference_browser_derived__baseline_clients_last_seen__v1 is failing since exec_date 2024-06-20

Task link:
https://workflow.telemetry.mozilla.org/dags/bqetl_glean_usage/grid?dag_run_id=scheduled__2024-06-19T02%3A00%3A00%2B00%3A00&task_id=reference_browser.checks__warn_org_mozilla_reference_browser_derived__baseline_clients_last_seen__v1&tab=logs

Log extract:

Min Row Count Error: 0 rows found, expected more than 1 rows

Comment 1

[Lucia Vargas]

This table has not had more than 5 client_ids per submission_date since 2023 and no more than 3 per submission_date in 2024.

Is this warning relevant considering that checks are auto-generated or should it maybe be ignored/excluded?

Comment 2

[BMO Github Automation]

Attachment: [mozilla/bigquery-etl] [Bug 1903788] Update checks for reference_browser_derived.baseline_clients_last_seen_v1 (#5842)

Comment 3

[Mike Williams [:mwilliams]]

Today this DAG has failures in a couple other tasks. They are both baseline_clients_last_seen_v1 so I'm going to record them here as that seems related.

• pine.checks__warn_pine_derived__baseline_clients_last_seen__v1
• fenix.checks__warn_org_mozilla_firefox_derived__baseline_clients_last_seen__v1