DynamoDB local index not updated when data inserted in table

Question

Hello,

Considering the below use-case:
- create DynamoDB table with local index, from Management Console (Local Index Sort Key same name as Table Partition Key; need to query table PK)
- create one Item in the table from  Management Console
- expect that the index will contain data related to the created item
- Management Console PartiQL returns the data from table
-  when use Management Console PartiQL to select data from index, no data is returned : `select * from PictureTextKeyPhrases.PartitionKeyIndex`

Why is this behaviour ?

Thank you,  
Mihai ADAM

Answer

The reason for your issue is how you define your statement, DynamoDB thinks you are trying to access a table called `PictureTextKeyPhrases.PartitionKeyIndex`, however your table is `PictureTextKeyPhrases` and your index `PartitionKeyIndex`, so you should use the following syntax:

```sql
SELECT * FROM "PictureTextKeyPhrases"."PartitionKeyIndex"
```

DynamoDB local index not updated when data inserted in table

Relevant content