Sorry, old thread, but I wanted to point out that <a href="http://quarry.wmflabs.org">http://quarry.wmflabs.org</a> seems like a good tool for this use case.<br><br>On Wednesday, December 24, 2014, Leila Zia &lt;<a href="mailto:leila@wikimedia.org">leila@wikimedia.org</a>&gt; wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><div class="gmail_extra">Hi Neta,<br><br></div><div class="gmail_extra"><div class="gmail_quote">On Wed, Dec 24, 2014 at 7:19 AM, Neta Livneh <span dir="ltr">&lt;<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;neta.livneh@gmail.com&#39;);" target="_blank">neta.livneh@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br><div>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&#39;s direction. </div></div></blockquote><div><br></div><div>Feel free to keep me in the loop for the latter.<br><br>Best,<br>Leila<br></div><div> </div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr"><br></div><div><div><div class="gmail_extra"><br><div class="gmail_quote">On Wed, Dec 24, 2014 at 4:39 PM, Aaron Halfaker <span dir="ltr">&lt;<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;ahalfaker@wikimedia.org&#39;);" target="_blank">ahalfaker@wikimedia.org</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div dir="ltr">Here&#39;s the instructions that Christian gave with some screenshots and discussion: <a href="https://meta.wikimedia.org/wiki/Research:Labs2/Getting_started_with_Tool_Labs" target="_blank">https://meta.wikimedia.org/wiki/Research:Labs2/Getting_started_with_Tool_Labs</a><div><br></div><div>If you&#39;re just looking to run a few queries, you might consider <a href="http://quarry.wmflabs.org" target="_blank">http://quarry.wmflabs.org</a> which requires no shell access -- just a Wikimedia sites account.  </div><div><br></div><div>-Aaron</div></div><div class="gmail_extra"><br><div class="gmail_quote"><div><div>On Wed, Dec 24, 2014 at 7:22 AM, Christian Aistleitner <span dir="ltr">&lt;<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;christian@quelltextlich.at&#39;);" target="_blank">christian@quelltextlich.at</a>&gt;</span> wrote:</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>Hi Neta,<br>
<span><br>
On Wed, Dec 24, 2014 at 11:28:33AM +0200, Neta Livneh wrote:<br>
&gt; For my project, we will need to sql queries on current wikipedia data<br>
&gt; (mostly revision history table).<br>
&gt;<br>
&gt; I already have a Gerrit account. Can I get SSH access for running such<br>
&gt; queries?<br>
<br>
</span>It sounds like the redacted labs databases would nicely fit your use<br>
case. The easiest way to get access there is to apply for Tool Labs [1].<br>
<br>
To get access, please file a request through<br>
<br>
  <a href="https://wikitech.wikimedia.org/wiki/Special:FormEdit/Tools_Access_Request" target="_blank">https://wikitech.wikimedia.org/wiki/Special:FormEdit/Tools_Access_Request</a><br>
<br>
(Many parts around the WMF are currently getting migrated to<br>
<a href="http://phabricator.wikimedia.org" target="_blank">phabricator.wikimedia.org</a>, so if someone knows a phabricator procedure<br>
for that please chime in!)<br>
<br>
<br>
Once you&#39;ve got Tool Labs [1] access you can ssh to<br>
<br>
  <a href="http://tools-login.wmflabs.org" target="_blank">tools-login.wmflabs.org</a><br>
<br>
and running<br>
<br>
  sql enwiki<br>
<br>
on that host connects you to labsdb&#39;s enwiki database and you can run<br>
your queries there (similar for other wikis).<br>
<br>
Have fun,<br>
Christian<br>
<br>
<br>
<br>
[1] <a href="https://wikitech.wikimedia.org/wiki/Help:Tool_Labs" target="_blank">https://wikitech.wikimedia.org/wiki/Help:Tool_Labs</a><br>
has more information and links about Tool Labs.<br>
<span><font color="#888888"><br>
<br>
--<br>
---- quelltextlich e.U. ---- \\ ---- Christian Aistleitner ----<br>
                           Companies&#39; registry: 360296y in Linz<br>
Christian Aistleitner<br>
Kefermarkterstrasze 6a/3     Email:  <a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;christian@quelltextlich.at&#39;);" target="_blank">christian@quelltextlich.at</a><br>
4293 Gutau, Austria          Phone:          <a href="tel:%2B43%207946%20%2F%2020%205%2081" value="+43794620581" target="_blank">+43 7946 / 20 5 81</a><br>
                             Fax:            <a href="tel:%2B43%207946%20%2F%2020%205%2081" value="+43794620581" target="_blank">+43 7946 / 20 5 81</a><br>
                             Homepage: <a href="http://quelltextlich.at/" target="_blank">http://quelltextlich.at/</a><br>
---------------------------------------------------------------<br>
</font></span><br></div></div>_______________________________________________<br>
Analytics mailing list<br>
<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;Analytics@lists.wikimedia.org&#39;);" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div></div>
<br>_______________________________________________<br>
Analytics mailing list<br>
<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;Analytics@lists.wikimedia.org&#39;);" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><br></div>
</div></div><br>_______________________________________________<br>
Analytics mailing list<br>
<a href="javascript:_e(%7B%7D,&#39;cvml&#39;,&#39;Analytics@lists.wikimedia.org&#39;);" target="_blank">Analytics@lists.wikimedia.org</a><br>
<a href="https://lists.wikimedia.org/mailman/listinfo/analytics" target="_blank">https://lists.wikimedia.org/mailman/listinfo/analytics</a><br>
<br></blockquote></div><br></div></div>
</blockquote>