I’m very excited to share some updates from ops on analytics-store.eqiad.wmnet [1] aka “the one box to rule them all”.
This box (which you access with the “research" SQL credentials) gives you:
1) read access to replicas of all production DBs consolidated on a single machine
2) read access to all EventLogging data via the log DB
3) read/write access to a shared staging DB that can be used as scratch space for temporary tables (similar to the staging DB on s1-analytics). If you create tables on staging, please prefix them with your shell user id (e.g. dartar_foo).
This is one of the best news I got from ops since I joined WMF and it will make my work way easier – thanks Sean and anybody else who helped make this happen.
Ops is also working on a solution to consolidate all credentials for analytics databases in a single place, via the creation of a “researcher” user group [2]. I’lll send a not one the list when this is completed
Dario
[1] a CNAME for dbstore1002.eqaid.wmnet.