Hi I m trying to add a secondary global index to a `sst Tabl Serverless Stack #help

Hi! I'm trying to add a secondary global index to ...

Andrew Blaney

07/01/2021, 1:49 PM

Hi! I'm trying to add a secondary global index to a

sst.Table

that already exists, with 1 existing secondary index. I've tried adding it to

TableProps.secondaryIndexes

property of the table, and also tried using

table.dynamodbTable.addGlobalSecondaryIndex()

but when I deploy, no changes are found for the stack.. any ideas? thanks!

Frank

07/01/2021, 5:21 PM

Hey @Andrew Blaney, can you share a code snippet of how you are defining the

sst.Table

and adding the index?

Andrew Blaney

07/01/2021, 5:23 PM

hey @Frank thanks for getting back to me.. this is the code for adding it using

Copy code

table.dynamodbTable.addGlobalSecondaryIndex

as adding it to

secondaryIndexes.gsi2

property of the below

sst.Table

call didnt make any changes

Copy code

const table = new sst.Table(this, 'theTable', {
      fields: {
        pk: sst.TableFieldType.STRING,
        sk: sst.TableFieldType.STRING,
        gsi1pk: sst.TableFieldType.STRING,
        gsi1sk: sst.TableFieldType.STRING,
        gsi2pk: sst.TableFieldType.STRING,
        gsi2sk: sst.TableFieldType.STRING,
      },
      primaryIndex: {
        partitionKey: 'pk',
        sortKey: 'sk',
      },
      secondaryIndexes: {
        gsi1: {
          partitionKey: 'gsi1pk',
          sortKey: 'gsi1sk',
          indexProps: {
            projectionType: ProjectionType.ALL,
          },
        },
      },
      dynamodbTable: {
        removalPolicy: env.database.removalPolicy,
        pointInTimeRecovery: true,
        timeToLiveAttribute: 'expiresAt',
      },
      stream: true,
    });

    table.dynamodbTable.addGlobalSecondaryIndex({
      projectionType: ProjectionType.KEYS_ONLY,
      indexName: 'gsi2',
      partitionKey: { name: 'gsi2pk', type: AttributeType.STRING },
      sortKey: { name: 'gsi2sk', type: AttributeType.STRING },
    });

Andrew Blaney

07/02/2021, 3:28 PM

is this what you were expecting to see @Frank?

Frank

07/02/2021, 5:48 PM

Sorry @Andrew Blaney, missed ur previous msg. Lemme give it a try.

Frank

07/04/2021, 6:39 PM

Hey @Andrew Blaney, I just gave your code a try, it seems to work for me.

Frank

07/04/2021, 6:41 PM

This is the entire stack definition. I had the 2nd GSI commented out and ran

sst deploy

, that created the table with

gsi1

Frank

07/04/2021, 6:41 PM

Then I uncommented the 2nd GSI and ran

sst deploy

again.

Frank

07/04/2021, 6:48 PM

Just curious, have you manually removed the GSI from the table manually (ie. from AWS console)?

Frank

07/04/2021, 6:49 PM

^as an aside, why call

addGlobalSecondaryIndex

instead of configuring both GSIs in

TableProps.secondaryIndexes

Andrew Blaney

07/05/2021, 9:45 AM

sorry frank, I've just removed my stack and re-created it with one GSI and then added the commented out code and deployed and again and everything looks fine. thanks for your help, I'm unsure what I did wrong the first time!

Frank

07/05/2021, 4:59 PM

No worries! Glad u got it to work!

Open in Slack

Previous Next