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 <[email protected]> wrote: > Hi Neta, > > On Wed, Dec 24, 2014 at 7:19 AM, Neta Livneh <[email protected] > <javascript:_e(%7B%7D,'cvml','[email protected]');>> 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 <[email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');>> 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 < >>> [email protected] >>> <javascript:_e(%7B%7D,'cvml','[email protected]');>> 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: [email protected] >>>> <javascript:_e(%7B%7D,'cvml','[email protected]');> >>>> 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 >>>> Fax: +43 7946 / 20 5 81 >>>> Homepage: http://quelltextlich.at/ >>>> --------------------------------------------------------------- >>>> >>>> _______________________________________________ >>>> Analytics mailing list >>>> [email protected] >>>> <javascript:_e(%7B%7D,'cvml','[email protected]');> >>>> https://lists.wikimedia.org/mailman/listinfo/analytics >>>> >>>> >>> _______________________________________________ >>> Analytics mailing list >>> [email protected] >>> <javascript:_e(%7B%7D,'cvml','[email protected]');> >>> https://lists.wikimedia.org/mailman/listinfo/analytics >>> >>> >> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> <javascript:_e(%7B%7D,'cvml','[email protected]');> >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
