1673903 - add urlbar-searchmode to allowed SAP sources

Status: RESOLVED FIXED

(Data Platform and Tools :: General, task)

Description

[Mike Connor [:mconnor]]

Splitting this out from

We need to add urlbar-searchmode to the list of allowed sources in search_* DBs, like we did in bug 1514021. we're currently not seeing searches on beta because of this:

https://github.com/mozilla/bigquery-etl/blob/bd2fc3005c29ead373ea0123485440381cd7febf/sql/moz-fx-data-shared-prod/search_derived/search_clients_daily_v8/query.sql#L54

https://github.com/mozilla/bigquery-etl/blame/003f9a7090b94d06489444e99bf0f1033069d2c8/sql/moz-fx-data-shared-prod/udf/aggregate_search_counts/udf.sql#L16

Comment 1

[GitHub Bugzilla PR Linker]

Attachment: Link to GitHub pull-request: https://github.com/mozilla/bigquery-etl/pull/1494

Comment 2

[William Lachance (:wlach)]

:mconnor, the pr above is about to be merged, which should result in data after today having this metadata. (how badly) do you need a backfill?

Comment 3

[Mike Connor [:mconnor]]

I think we'll be ok, as long as it's fine to use main_summary to pull beta numbers for ad hoc analysis.

Comment 4

[William Lachance (:wlach)]

Okay, awesome! Resolving this as fixed for now.