Thanks guys, I filed a request. I think I will be working constantly with the database so it will require shell access.
Actually, this is a great opportunity to say that I would love to get you guys involved or at least hear insights from the analytics team regarding the project's direction. I will probably check in again in a month or so when we will have better understanding regarding the direction my project is headed. Until then, here is a link to the project in phabricator: article-translation-metrics <https://phabricator.wikimedia.org/tag/article-translation-metrics/>. Merry Christmas, Neta neta.liv...@gmail.com On Wed, Dec 24, 2014 at 4:39 PM, Aaron Halfaker <ahalfa...@wikimedia.org> wrote: > Here's the instructions that Christian gave with some screenshots and > discussion: > https://meta.wikimedia.org/wiki/Research:Labs2/Getting_started_with_Tool_Labs > > If you're just looking to run a few queries, you might consider > http://quarry.wmflabs.org which requires no shell access -- just a > Wikimedia sites account. > > -Aaron > > On Wed, Dec 24, 2014 at 7:22 AM, Christian Aistleitner < > christ...@quelltextlich.at> wrote: > >> Hi Neta, >> >> On Wed, Dec 24, 2014 at 11:28:33AM +0200, Neta Livneh wrote: >> > For my project, we will need to sql queries on current wikipedia data >> > (mostly revision history table). >> > >> > I already have a Gerrit account. Can I get SSH access for running such >> > queries? >> >> It sounds like the redacted labs databases would nicely fit your use >> case. The easiest way to get access there is to apply for Tool Labs [1]. >> >> To get access, please file a request through >> >> >> https://wikitech.wikimedia.org/wiki/Special:FormEdit/Tools_Access_Request >> >> (Many parts around the WMF are currently getting migrated to >> phabricator.wikimedia.org, so if someone knows a phabricator procedure >> for that please chime in!) >> >> >> Once you've got Tool Labs [1] access you can ssh to >> >> tools-login.wmflabs.org >> >> and running >> >> sql enwiki >> >> on that host connects you to labsdb's enwiki database and you can run >> your queries there (similar for other wikis). >> >> Have fun, >> Christian >> >> >> >> [1] https://wikitech.wikimedia.org/wiki/Help:Tool_Labs >> has more information and links about Tool Labs. >> >> >> -- >> ---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ---- >> Companies' registry: 360296y in Linz >> Christian Aistleitner >> Kefermarkterstrasze 6a/3 Email: christ...@quelltextlich.at >> 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 >> Fax: +43 7946 / 20 5 81 >> Homepage: http://quelltextlich.at/ >> --------------------------------------------------------------- >> >> _______________________________________________ >> Analytics mailing list >> Analytics@lists.wikimedia.org >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> > _______________________________________________ > Analytics mailing list > Analytics@lists.wikimedia.org > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list Analytics@lists.wikimedia.org https://lists.wikimedia.org/mailman/listinfo/analytics