Change Details

== Goal The [[ https://superset.wikimedia.org/superset/dashboard/p/z0Gr4G5BxyP/ | IP Masking (Temp Accounts) guardrail metrics dashboard ]] currently is maintained by the product analytics team. The staging tables are fetched monthly by a cron job into a database under jwang's account. We plan to migrate the queries to Airflow, so that it can be fully automated and easily maintained. == Dependency Add `cu_log` to the data lake. T364398 ==To Do [x] Write updated SQL queries for table creation and updating [x] Write Airflow DAG [x] Build new version of tables [] Backfill old data to new tables T378518 [] Update metric queries to use new tables [] Update Superset dashboard to use new tables

== Goal The [[ https://superset.wikimedia.org/superset/dashboard/p/z0Gr4G5BxyP/ | IP Masking (Temp Accounts) guardrail metrics dashboard ]] currently is maintained by the product analytics team. The staging tables are fetched monthly by a cron job into a database under jwang's account. We plan to migrate the queries to Airflow, so that it can be fully automated and easily maintained. == Dependency Add `cu_log` to the data lake. T364398 ==To Do [x] Write updated SQL queries for table creation and updating [x] Write Airflow DAG [x] Build new version of tables [x] Backfill old data to new tables T378518 [x] Update metric queries to use new tables [x] Update Superset dashboard to use new tables

== Goal The [[ https://superset.wikimedia.org/superset/dashboard/p/z0Gr4G5BxyP/ | IP Masking (Temp Accounts) guardrail metrics dashboard ]] currently is maintained by the product analytics team. The staging tables are fetched monthly by a cron job into a database under jwang's account. We plan to migrate the queries to Airflow, so that it can be fully automated and easily maintained. == Dependency Add `cu_log` to the data lake. T364398 ==To Do [x] Write updated SQL queries for table creation and updating [x] Write Airflow DAG [x] Build new version of tables [x] Backfill old data to new tables T378518 [x] Update metric queries to use new tables [x] Update Superset dashboard to use new tables