Like T122524, kartik also planning to run queries on wikishared database. Also, serving as backup coordinator for amire80 (when not available). Please grant access to stat1002 to kartik.
Description
Details
Status | Subtype | Assigned | Task | ||
---|---|---|---|---|---|
Resolved | None | T135704 Add kartik to analytics-privatedata-users | |||
Restricted Task |
Event Timeline
I suggested this request so their queries can be done on analytics slaves instead of production slaves.
We will need manager's approval for this request for Kartik.
In the meanwhile, we can start the 3-day discussion time.
Noting that analytics-privatedata-users also gives Hadoop access on stat1002/4, unless this is required, the group for mysql analytics slaves from stat1003 should be the researchers group - https://github.com/wikimedia/operations-puppet/blob/f6950b59bbc81545f6080c1d97c30be305083457/modules/admin/data/data.yaml#L110
@KartikMistry already has access to stat1003 through being in statistics-users - adding him to researchers gives access to the conf files that have relevant passwords to access mysql. https://wikitech.wikimedia.org/wiki/Analytics/Data_access#Access_Groups
Change 290169 had a related patch set uploaded (by Giuseppe Lavagetto):
admin: add kartik to analytics-privatedata-users
Speaking with @madhuvishy, she realized that we were wrong: @Amire80 has permissions to query hadoop as well, and that is apparently needed (see T122524) so since Kartik needs to be a backup for him, let's add him to analytics-privatedata-users instead.
Change 290170 had a related patch set uploaded (by Giuseppe Lavagetto):
admin: add kartik to analytics-privatedata-users instead
Change 290170 merged by Giuseppe Lavagetto:
admin: add kartik to analytics-privatedata-users instead