Run a query so that we can test the following hypothesis:
"If we introduce the ability for volunteers to add template favourites, then at least 1,000 contributors will favourite 1 template."
To query across the cluster, we'll likely use the wmfdata-python library on a stats machine.
Notes for debugging:
- on test.wikipedia, my user ID is 9999
wikiadmin2023@10.64.32.82(testwiki)> select * from user_properties where up_user = 9999 and up_property = 'templatedata-favorite-templates' limit 2; +---------+---------------------------------+---------------+ | up_user | up_property | up_value | +---------+---------------------------------+---------------+ | 9999 | templatedata-favorite-templates | [13450,90327] | +---------+---------------------------------+---------------+