seems like a good tool for this use case.
On Wednesday, December 24, 2014, Leila Zia <leila(a)wikimedia.org> wrote:
Hi Neta,
On Wed, Dec 24, 2014 at 7:19 AM, Neta Livneh <neta.livneh(a)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(a)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_La…
>>
>> 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(a)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(a)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(a)lists.wikimedia.org
>>>
https://lists.wikimedia.org/mailman/listinfo/analytics
>>>
>>>
>> _______________________________________________
>> Analytics mailing list
>> Analytics(a)lists.wikimedia.org
>>
https://lists.wikimedia.org/mailman/listinfo/analytics
>>
>>
>
> _______________________________________________
> Analytics mailing list
> Analytics(a)lists.wikimedia.org
>
https://lists.wikimedia.org/mailman/listinfo/analytics
>
>
_______________________________________________
Analytics mailing list
Analytics(a)lists.wikimedia.org