Here's the instructions that Christian gave with some screenshots and discussion: https://meta.wikimedia.org/wiki/Research:Labs2/Getting_started_with_Tool_Lab...
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 < christian@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: christian@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