yeah, I do have access - Thanks! I already used ssh, and also used the quarry tool for smaller quick queries.
Cheers, Neta On Thu, Jan 15, 2015 at 7:35 PM, Neta Livneh <[email protected]> wrote: > > > On Thu, Jan 15, 2015 at 4:42 PM, Dan Andreescu <[email protected]> > wrote: > >> 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]> >>> 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]> 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]> 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] >>>>>> 4293 Gutau, Austria Phone: +43 7946 / 20 5 81 >>>>>> Fax: +43 7946 / 20 5 81 >>>>>> Homepage: http://quelltextlich.at/ >>>>>> --------------------------------------------------------------- >>>>>> >>>>>> _______________________________________________ >>>>>> Analytics mailing list >>>>>> [email protected] >>>>>> https://lists.wikimedia.org/mailman/listinfo/analytics >>>>>> >>>>>> >>>>> _______________________________________________ >>>>> Analytics mailing list >>>>> [email protected] >>>>> https://lists.wikimedia.org/mailman/listinfo/analytics >>>>> >>>>> >>>> >>>> _______________________________________________ >>>> Analytics mailing list >>>> [email protected] >>>> https://lists.wikimedia.org/mailman/listinfo/analytics >>>> >>>> >>> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
