Replace athena query with cloudwatch insights in the usage email lambda
Closed, ResolvedPublic8 Estimated Story Points
Actions

Assigned To

Authored By

	prabhat
	Aug 4 2022, 1:18 PM

Description

Emailing lambda makes advanced athena queries to get the usage data for the current running month. These queries help to find out the users who are approaching their quotas in terms of allowed requests.

We want to replace the athena queries with cloudwatch insights queries. This will effectively make athena service redundant and we will have one less lambda to maintain.

Acceptance criteria:
Userdata gets enqueued in to the sqs queue after getting it from log insights and processing it.

Event Timeline

prabhat created this task.Aug 4 2022, 1:18 PM

Restricted Application added a subscriber: Aklapper. · View Herald TranscriptAug 4 2022, 1:18 PM

Protsack.stephan moved this task from Incoming to To Be Estimated/To Be Discussed on the Wikimedia Enterprise board.Aug 9 2022, 12:50 PM

Protsack.stephan triaged this task as High priority.Aug 11 2022, 11:55 AM

• Lena.Milenko set the point value for this task to 8.Aug 11 2022, 2:32 PM

• Lena.Milenko moved this task from To Be Estimated/To Be Discussed to Estimated /Discussed on the Wikimedia Enterprise board.Aug 11 2022, 3:03 PM

prabhat moved this task from Estimated /Discussed to In Progress on the Wikimedia Enterprise board.Aug 16 2022, 3:55 PM

prabhat renamed this task from Make cloudwatch log processing concurrent to Replace athena query with cloudwatch insights in the usage email lambda.Aug 16 2022, 4:03 PM

prabhat changed the task status from Open to In Progress.

prabhat updated the task description. (Show Details)

Protsack.stephan moved this task from In Progress to Merge Request on the Wikimedia Enterprise board.Aug 25 2022, 1:11 PM

prabhat updated the task description. (Show Details)Aug 25 2022, 2:26 PM

Protsack.stephan moved this task from Merge Request to Done Sprint 23 (11Aug-07Sep2022) on the Wikimedia Enterprise board.Aug 29 2022, 10:09 AM

Protsack.stephan moved this task from Done Sprint 23 (11Aug-07Sep2022) to Merge Request on the Wikimedia Enterprise board.

Protsack.stephan moved this task from Merge Request to Machine Readability PB on the Wikimedia Enterprise board.Aug 29 2022, 6:19 PM

Protsack.stephan moved this task from Machine Readability PB to Done Sprint 24 (08Sep-21Sep2022) on the Wikimedia Enterprise board.Sep 26 2022, 5:55 PM

• Lena.Milenko changed the task status from In Progress to Open.Oct 3 2022, 12:56 AM

AnnaMikla closed this task as Resolved.Oct 14 2022, 10:25 AM