abcxyz / abcxyz/github-metrics-aggregator

Use a limited time window when looking for duplicates

Open
#138 0 comments 0 reactions 0 assignees View on GitHub
enhancement good first issue
Dominant language
Go
Stars
16
Forks
3
PR merge metrics
No merged PRs in 30d

Description

Currently before we add to the PubSub topic, we do a query to ensure the row doesn't already exist in the table:
https://github.com/abcxyz/github-metrics-aggregator/blob/bae8a213956a38ffb2ca721820c92af0235bde2c/pkg/webhook/bigquery.go#L117

It would be better if we used a WHERE to limit the amount of data that gets scanned to something more like a week.

This should probably be done by adding an additional argument to the chain of functions this is the base of.

This is low priority since the payload column isn't selected.

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.