Skip to content

Instantly share code, notes, and snippets.

@ketankhairnar

ketankhairnar/pre-aggegations-data-access-pattern-example.txt

Last active September 5, 2021 15:26
Show Gist options
  • Save ketankhairnar/aa41266bfe97fa336540166927f54414 to your computer and use it in GitHub Desktop.
Save ketankhairnar/aa41266bfe97fa336540166927f54414 to your computer and use it in GitHub Desktop.
Download ZIP
pre-aggegations-data-access-pattern-example.txt
Raw
pre-aggegations-data-access-pattern-example.txt
┌──────────────────────────────┬────────────────────┬─────────────────────────────────────────────────┐
│ Question │ Attr Params │ Sample Args │
├──────────────────────────────┼────────────────────┼─────────────────────────────────────────────────┤
│ Last n Days spend for card │ card,Day1-Day n │ card#ABCD,(Day-2021-09-05,Day-2021-08-30) │
│ Last 4 Weeks spend for user │ user,Week 1-Week 7 │ user#1234,(Week-2021-36,Week-2021-33) │
│ Total spend for organization │ org,Total │ org#12AB,(Total) │
│ Monthwise Purchase for Team │ team,Month │ org#12AB#team#22,(Month-2021-06, Month-2021-02) │
└──────────────────────────────┴────────────────────┴─────────────────────────────────────────────────┘
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment