Sorry, old thread, but I wanted to point out that http://quarry.wmflabs.org seems like a good tool for this use case.

On Wednesday, December 24, 2014, Leila Zia <leila@wikimedia.org> wrote:

Hi Neta,

On Wed, Dec 24, 2014 at 7:19 AM, Neta Livneh <neta.livneh@gmail.com> wrote:

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.

Feel free to keep me in the loop for the latter.

Best,
Leila

 

On Wed, Dec 24, 2014 at 4:39 PM, Aaron Halfaker <ahalfaker@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 <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

_______________________________________________
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