Is there an “easy” way to run a query on a subset of the data without re-writing the query.
For example, we know that 94.4% of websites use at least one third-party resource (source: Third Parties | 2021 | The Web Almanac by HTTP Archive). If I wanted to re-run this query to find out how many WordPress websites are using at least one third-party resource; would I need to write a new query? Similarly, if I want to run the query on the Top 1,000 sites.
If there are views (referring to SQL Views) which already filter out the data according to some predefined conditions, then I would be able to change the FROM statement to point to the new table.
Example:
FROM
`httparchive.summary_requests.2021_07_01_*`
to
FROM
`httparchive.wordpress.summary_requests.2021_07_01_*`
I know there is the concept of “lens”, but I’m not sure how it can be applied. Thanks