Skip to content

Instantly share code, notes, and snippets.

@emtwo

emtwo/gist:d08c74a434b32bf0cb01c1b47c3bdbe7

Last active November 20, 2019 19:03
Show Gist options
  • Save emtwo/d08c74a434b32bf0cb01c1b47c3bdbe7 to your computer and use it in GitHub Desktop.
Save emtwo/d08c74a434b32bf0cb01c1b47c3bdbe7 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
CREATE OR REPLACE VIEW
`moz-fx-data-shared-prod.telemetry.client_probe_counts`
AS SELECT
*
FROM
`moz-fx-data-shared-prod.telemetry_derived.client_probe_counts_v1`
WHERE metric != "search_counts"
AND metric NOT LIKE "%browser_search%"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment