T416478 Remove filtered user agents from queries (!57) · Merge requests · repos / Wikimedia Deutschland / Analytics · GitLab

How to register an account on GitLab. Due to spam, new accounts are locked until approved by an admin or the approver bot. Your GitLab account gets automatically approved within one hour if you are a member of Trusted Contributors in Gerrit, or a member of the Trusted-Contributors group in Phabricator and linked your Developer account ("LDAP") to your Phabricator account. If none of these apply, file an unlock request to expedite access. Only if you are WMF staff: Create your GitLab account, have "Wmf" group membership in IDM, link your Developer account ("LDAP") to your Phabricator account, and get automatically approved.

Support: mw:GitLab, how to host a project on GitLab, #wikimedia-gitlab on libera.chat, #GitLab on Phabricator.

Contributor checklist

I have checked all files included in this merge request for data that should not be publicly released
Code formatting and conventions are in line with the WMDE Analytics contributing guide
All changes from the main branch have been rebased into this branch

Description

T416478: Removes the total_filtered_user_agents fields from processes that have it and adds a note about it to the notebook where it was originally worked on as documentation.
Note: Normally in changing schemas I'd say it would be important to log the decisions, but I'd argue that we should not do this in this case as we need to move passed this idea and I don't want future analysts asking what it was and whether it makes sense (as it doesn't).

This MR adds or updates queries that are being ran in the WMDE Airflow instance. The related MR to update the DAG(s) including the query commit SHA-1s is:

The Airflow repo will be updated after this is merged.