DynamoDB custom index serverless.yml example

serverless.yml

service: service-name

provider:
  name: aws
  runtime: nodejs6.10

functions:
  myfunc:
    handler: handler.myfunc
    events:
      - http:
          path: myfunc
          method: post
          cors: true

resources:
  Resources:
    myDynamoDBTable:
      Type: AWS::DynamoDB::Table
      Properties:
        AttributeDefinitions:
        - AttributeName: Album
          AttributeType: S
        - AttributeName: Artist
          AttributeType: S
        - AttributeName: Sales
          AttributeType: N
        KeySchema:
        - AttributeName: Album
          KeyType: HASH
        - AttributeName: Artist
          KeyType: RANGE
        ProvisionedThroughput:
          ReadCapacityUnits: '5'
          WriteCapacityUnits: '5'
        TableName: myTableName
        GlobalSecondaryIndexes:
        - IndexName: myGSI
          KeySchema:
          - AttributeName: Sales
            KeyType: HASH
          - AttributeName: Artist
            KeyType: RANGE
          Projection:
            NonKeyAttributes:
            - Album
            ProjectionType: INCLUDE
          ProvisionedThroughput:
            ReadCapacityUnits: '5'
            WriteCapacityUnits: '5'
        LocalSecondaryIndexes:
        - IndexName: myLSI
          KeySchema:
          - AttributeName: Album
            KeyType: HASH
          - AttributeName: Sales
            KeyType: RANGE
          Projection:
            NonKeyAttributes:
            - Artist
            ProjectionType: INCLUDE
    mySecondDDBTable:
      Type: AWS::DynamoDB::Table
      DependsOn: myDynamoDBTable
      Properties:
        AttributeDefinitions:
        - AttributeName: ArtistId
          AttributeType: S
        - AttributeName: Concert
          AttributeType: S
        - AttributeName: TicketSales
          AttributeType: S
        KeySchema:
        - AttributeName: ArtistId
          KeyType: HASH
        - AttributeName: Concert
          KeyType: RANGE
        TableName: myTableName2
        ProvisionedThroughput:
          ReadCapacityUnits: '5'
          WriteCapacityUnits: '5'
        GlobalSecondaryIndexes:
        - IndexName: myGSI
          KeySchema:
          - AttributeName: TicketSales
            KeyType: HASH
          Projection:
            ProjectionType: KEYS_ONLY
          ProvisionedThroughput:
            ReadCapacityUnits: '5'
            WriteCapacityUnits: '5'

My problem was you can not have two - IndexName sections in the GlobalSecondaryIndexes section due to a limitation in CloudFormation. Only one GSI action can be run at a time.

If you want more than one GSI, you have to add them one at a time and wait for them to complete by watching the console. Also make sure to add a new section and not delete an existing section or CF will think you're trying to remove and add an index, which is two operations, and it will fail.

Hi can this be possible in dynamodb
I am trying to create a table with platform, profileid, and username attributes. it is giving error that

ValidationException: Hash Key not specified in Attribute Definitions. Type unknown.: DynamoDB - Error

I want my schema like that

ProfileTable:
  Type: AWS::DynamoDB::Table
  Properties:
    TableName: ProfileTable
    AttributeDefinitions:
      -
        AttributeName: platform
        AttributeType: S
      -
        AttributeName: profileid
        AttributeType: S
      -
        AttributeName: username
        AttributeType: S
    KeySchema:
      -
        AttributeName: platform
        KeyType: RANGE
      -
        AttributeName: profileid__username
        KeyType: HASH
    ProvisionedThroughput:
      ReadCapacityUnits: ${self:custom.db.rcu}
      WriteCapacityUnits: ${self:custom.db.wcu}

Hi can this be possible in dynamodb
I am trying to create a table with platform, profileid, and username attributes. it is giving error that

ValidationException: Hash Key not specified in Attribute Definitions. Type unknown.: DynamoDB - Error

I want my schema like that

ProfileTable:
  Type: AWS::DynamoDB::Table
  Properties:
    TableName: ProfileTable
    AttributeDefinitions:
      -
        AttributeName: platform
        AttributeType: S
      -
        AttributeName: profileid
        AttributeType: S
      -
        AttributeName: username
        AttributeType: S
    KeySchema:
      -
        AttributeName: platform
        KeyType: RANGE
      -
        AttributeName: profileid__username
        KeyType: HASH
    ProvisionedThroughput:
      ReadCapacityUnits: ${self:custom.db.rcu}
      WriteCapacityUnits: ${self:custom.db.wcu}

Your HASH key needs to be an Attribute as well, so add it like you added platform.