Closed
Bug 1592848
Opened 6 years ago
Closed 5 years ago
Create a view for monitoring missing columns in BigQuery ping tables
Categories
(Data Platform and Tools :: General, enhancement, P2)
Data Platform and Tools
General
Tracking
(Not tracked)
RESOLVED
FIXED
People
(Reporter: amiyaguchi, Assigned: amiyaguchi)
Details
Attachments
(1 file)
Data not captured in a schema in mozilla-pipeline-schema will get put into a JSON column called additional_properties in the BigQuery ping tables. We would like to know what columns are missing from the ping, so we can monitor and improve the coverage of our schemas over time.
There should be a view over all of the enumerated paths in the additional_properties column.
|
||
Comment 1•6 years ago
|
||
|
Assignee | |
Comment 2•6 years ago
|
||
This view has been merged in, but it is not yet available for use.
https://sql.telemetry.mozilla.org/queries/65797/source
It may have to be manually deployed.
Assignee: nobody → amiyaguchi
|
||
Updated•6 years ago
|
Points: --- → 1
Priority: -- → P2
|
|
Assignee | |
Updated•5 years ago
|
Status: NEW → RESOLVED
Closed: 5 years ago
Resolution: --- → FIXED
|
||
Updated•3 years ago
|
Component: Datasets: General → General
You need to log in
before you can comment on or make changes to this bug.
Description
•