Page MenuHomePhabricator

Requesting access to EventLogging in Hive (analytics-privatedata-users) for Cicalese
Closed, ResolvedPublic

Description

Username: cicalese
Full name: Cindy Cicalese

I already have access to stats1006/researchers. I need access to hive for analysis of the EU Copyright landing page (fixcopyright.wikimedia.org) page view and eventlogging statistics. This is needed ASAP, since it is necessary to validate data for a site in development that will go live early next week.

Event Timeline

Restricted Application added a subscriber: Aklapper. · View Herald Transcript

Change 456763 had a related patch set uploaded (by Dzahn; owner: Dzahn):
[operations/puppet@production] admins: add ccicalese to analytics-privatedata-admins

https://gerrit.wikimedia.org/r/456763

analytics-privatedata-users sounds right per https://wikitech.wikimedia.org/wiki/Analytics/Systems/Cluster/Hive

@Nuria @mark Do i have approval to resolve this without the usual waiting period due to the urgency described by Cindy

https://wikitech.wikimedia.org/wiki/Production_shell_access#Additional_permissions_for_existing_users

Yes, this can be merged once Nuria approves.

I have sent mail to Nuria, given that phab notifications aren't always the first thing people see when checking their backlogs from the weekend.

@CCicalese_WMF The data is also on the mysql data store (to which you already have access) so you can verify there. Per our conversation, data on hive includes extra fields that MySQL does not have, like geocoded_data (with country information) . Now, in the case of your events there are no records on hive that do not appear in MySQL

Request is approved but to be clear, there is no urgency.

@Nuria, right, but as we discussed, I'm looking for the geocoded data. Before this goes live, I want to verify that I can appropriately query and get the necessary information from the data that is being captured.

Change 456763 merged by Dzahn:
[operations/puppet@production] admins: add ccicalese to analytics-privatedata-admins

https://gerrit.wikimedia.org/r/456763

Change 457959 had a related patch set uploaded (by Dzahn; owner: Dzahn):
[operations/puppet@production] admins: fix cicalese's user name in analytics-privatedata-users

https://gerrit.wikimedia.org/r/457959

Change 457959 merged by Dzahn:
[operations/puppet@production] admins: fix cicalese's user name in analytics-privatedata-users

https://gerrit.wikimedia.org/r/457959

@CCicalese_WMF on stat1004/stat1005 your user has been added to the additional group. Let us know if it works for you.

Thank you! I was able to log in to both successfully.

Alright, thanks for confirming. I'll close this as resolved then.