AWS: DynamoDb Reminders

3/5/2021 5:32:34 PM

Tables

  • 10 Gb Max per Partition (table and indexes)
  • 400 Kb Max per Row (includes data and column names)
  • Partitions based on PK

Global Secondary Indexes (GSI)

  • Index across partitions
  • Have their own Read/Write capacity and cost
  • Copy attributes (duplicates data and cost)

Local Secondary Indexes (LSI)

  • Index within a partition
  • Hash is same as PK of table
  • Essentially adds a second sort index
  • copy attributes (duplicates data and cost)

Queries

  • Cannot do a BeginsWith query on a PK, only a sort key
  • Cannot query a Sort Key alone (need to have PK)