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 <neta.livneh(a)gmail.com>
wrote:
On Thu, Jan 15, 2015 at 4:42 PM, Dan Andreescu
<dandreescu(a)wikimedia.org> 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 <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
>
https://lists.wikimedia.org/mailman/listinfo/analytics
>