Query snapshot data for current active accounts

Open
#2,547 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

Assessment

Difficulty
4/5
Estimated time
3-5 days
Newbie friendliness
45/100
Issue type
Feature
Clarity
Mostly clear
Activity status
Active
Tech stack
google-cloud
Domain
cloud, data, databases

Research direction

Start by reading the STOR-687 snapshot details and the linked Google Doc, then confirm the relevant BigQuery datasets and coordinate with FxA on the table name and staleness handling. Done means the x_modified table and two-year UID table exist, the UID table is retained for at least two years, and its copy is available in the FxA BigQuery dataset.

Written by the indexing model from the issue text.

Description

Use the snapshot created in https://mozilla-hub.atlassian.net/browse/STOR-687 to create an updated “x_modified” table in BQ per https://docs.google.com/document/d/1LWxfB6edrXxvDONFFz9xQ2gV5ZyfPPOvoe__nzo_4H4. Create another table by selecting the uids from x_modified where modified is two years ago or newer. Ensure this table of uids does not expire for at least two years.

Copy the table of uids to FxA BigQuery dataset where it will be used for inactive account filtering. Work with FxA on the name of the table. Ensure that FxA will skip the staleness check on this table.

┆Issue is synchronized with this Jira Task

Dominant language
Rust
Stars
1.8k
Forks
86
Avg merge
2d 17h
Merged PRs (30d)
21

Contributor guide

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. Open a pull request that references the issue number.

More from mozilla-services/syncstorage-rs

All issues in mozilla-services/syncstorage-rs

Similar issues

More Rust issues

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.