By using AWS re:Post, you agree to the AWS re:Post Terms of Use

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

asked 10 months ago447 views
1 Answer
1
Accepted Answer

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.

answered 10 months ago
profile picture
EXPERT
reviewed 9 months ago
  • I guess you are right. Thanks!

You are not logged in. Log in to post an answer.

A good answer clearly answers the question and provides constructive feedback and encourages professional growth in the question asker.

Guidelines for Answering Questions