Help us improve the AWS re:Post Knowledge Center by sharing your feedback in a brief survey. Your input can influence how we create and update our content to better support your AWS journey.
Help in modelling schema
0
Hey people, I would like this help.
I have this simple EDR shema.
My standard access is:
- Query transactions for stationId + fuelPointNumber per time (newest records)
- Query transactions for stationId + attendantId per time (newest records)
This is a modeling draft.
The question is, how could I resolve my query 2?
1 Answer
- Newest
- Most votes
- Most comments
0
Base Table
| pk | sk | gsipk | fpn | aid |
|---|---|---|---|---|
| sid#1234#fpn#123 | 2021-10-10T00:00:000 | sid#1234#aid#1 | 123 | 1 |
| sid#5678#fpn#321 | 2021-10-10T00:00:000 | sid#5678#aid#1 | 321 | 1 |
GSI
| gsipk | sk | pk | fpn | aid |
|---|---|---|---|---|
| sid#1234#aid#1 | 2021-10-10T00:00:000 | sid#1234#fpn#123 | 123 | 1 |
| sid#5678#aid#1 | 2021-10-10T00:00:000 | sid#5678#fpn#321 | 321 | 1 |
Relevant content
- asked 7 months ago
- AWS OFFICIALUpdated 7 months ago
