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 [] Write updated SQL queries for table creation and updating [] Write Airflow DAG [] Build new version of tables [] Backfill old data to new tables [] 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 [] Write Airflow DAG [] Build new version of tables [] Backfill old data to new tables [] 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 [] Write Airflow DAG [] Build new version of tables [] Backfill old data to new tables [] Update metric queries to use new tables [] Update Superset dashboard to use new tables