Please update queries: new name for search_clients_daily

6 views
Skip to first unread message

Jeff Klukas

unread,
May 20, 2021, 2:37:17 PM5/20/21
to fx-da...@mozilla.org
Data users - If you interact with search data [0], be aware that we are renaming the following views:

    search_clients_daily -> search_clients_engines_sources_daily
    mobile_search_clients_daily -> mobile_search_clients_engines_sources_daily

The "search_clients_daily" name has been causing confusion for some time, as it implies that the table has one row per client_id per day while in fact, the underlying model of these two tables has always been one row per (client_id, engine, source) combination per day. The new names, while annoyingly long, make the underlying grain of the data explicit.

They still exist for the time being, but we will be removing the old views in one month (on June 22). Please start using the new names and update any scheduled Redash queries, etc.


Jeff Klukas

unread,
Jun 22, 2021, 9:06:06 AM6/22/21
to fx-da...@mozilla.org
Data users - The old view names search_clients_daily and mobile_search_clients_daily have now been removed.

Redash queries were bulk updated last week to use the new names, but if you have any remaining use cases, you may see them break now. You can fix any breakage by making the following replacements:

    search_clients_daily -> search_clients_engines_sources_daily
    mobile_search_clients_daily -> mobile_search_clients_engines_sources_daily

Feel free to reach out in #data-help on Slack or in #telemetry on chat.mozilla.org if you have any questions.
Reply all
Reply to author
Forward
0 new messages