Skip to content

Queries for potential vandalism reverted by Automoderator

KCVelaga requested to merge kcvelaga/data-pipelines:vandal-handled-queries into main

Bug: T376456

Queries to calculate and publish data required to estimate potential vandalism reverted by Automoderator, along with other user types, on a monthly basis.

  • Table creation file: create_automoderator_potential_vandalism_reverted.hql
  • Monthly generation and load file: generate_automoderator_potential_vandalism_reverted.hql
  • Publishing a CSV to a temporary directory: publish_automoderator_potential_vandalism_reverted.hql
  • Removing snapshots older than 3 months: purge_automoderator_potential_vandalism_reverted.hql
Edited by KCVelaga

Merge request reports