Combine multiple base table attributes to form a DynamoDB GSI PK/SK

0

I am trying to create a GSI on a DynamoDB Table using AWS console by choosing PK or SK as combination of multiple base table attributes. However, none of the below formats are working for either PK or SK. Please guide me where I am doing wrong ?

  1. <custid>#<userid>
  2. [custid]#[userid]
  3. CUST#<custid>#USER#<userid>
  4. CUST#[custid]#USER#[userid]

Base Table has attributes: id (PK) (string), custid (string), userid (string)

#2 - Reference link(s): https://repost.aws/knowledge-center/dynamodb-create-composite-key https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/bp-sort-keys.html

#1,#3 - Reference link(s): https://www.alexdebrie.com/posts/dynamodb-one-to-many/#denormalization-by-using-a-complex-attribute:~:text=ORG%23%3COrgName%3E%23USER%23%3CUserName%3E

Mani
preguntada hace 3 meses123 visualizaciones
1 Respuesta
1
Respuesta aceptada

DynamoDB won't handle this for you. You'll need to construct the concatenated value on the application side and store as its own attribute in the base table.

respondido hace 3 meses
profile picture
EXPERTO
revisado hace 2 meses
  • I guess you are right. Thanks!

No has iniciado sesión. Iniciar sesión para publicar una respuesta.

Una buena respuesta responde claramente a la pregunta, proporciona comentarios constructivos y fomenta el crecimiento profesional en la persona que hace la pregunta.

Pautas para responder preguntas