As Oliver assumed, I will be using the publicly accessed data that can be found in the dumps, so I was asking for analytics-store access. Oliver, you are right, I should have elaborated my intentions in my original mail. I asked for access because we will work with the revision histories tables of the large wikipedias, and it will be impossible for me to work on it locally.
BTW, I'm not sure it is such a small project :) Neta On Wed, Dec 24, 2014 at 5:32 PM, Oliver Keyes <[email protected]> wrote: > Max, > > I imagine Neta was asking for analytics-store access, so not /really/ the > production cluster ;p. But, yes: generally-speaking "I need access to some > data for...something", is not likely to lead to access to dbs containing > sensitive information. > > On 24 December 2014 at 10:28, Max Semenik <[email protected]> wrote: > >> Access to production cluster, especially to databases that contain all >> kinds of user information, is an extremely big deal, so it's unlikely that >> this is going to happen, especially for a small one-time project. >> >> On Wed, Dec 24, 2014 at 7:19 AM, Neta Livneh <[email protected]> >> wrote: >> >>> Thanks guys, I filed a request. >>> >>> I think I will be working constantly with the database so it will >>> require shell access. >>> >>> 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. I will probably check in again in a >>> month or so when we will have better understanding regarding the direction >>> my project is headed. Until then, here is a link to the project in >>> phabricator: article-translation-metrics >>> <https://phabricator.wikimedia.org/tag/article-translation-metrics/>. >>> >>> Merry Christmas, >>> >>> Neta >>> [email protected] >>> >>> 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 >>> >>> >> >> >> -- >> Best regards, >> Max Semenik ([[User:MaxSem]]) >> >> _______________________________________________ >> Analytics mailing list >> [email protected] >> https://lists.wikimedia.org/mailman/listinfo/analytics >> >> > > > -- > Oliver Keyes > Research Analyst > Wikimedia Foundation > > _______________________________________________ > Analytics mailing list > [email protected] > https://lists.wikimedia.org/mailman/listinfo/analytics > >
_______________________________________________ Analytics mailing list [email protected] https://lists.wikimedia.org/mailman/listinfo/analytics
