Error: dynamodb global secondary index not working

A GSI query uses the index key schema, not necessarily the table key schema. Check IndexName, index status and the attribute names and types in your KeyConditionExpression.

• Wait for the index to become ACTIVE after creation or backfill.
• An item missing an index key attribute is not included in that sparse index.
• GSI reads are eventually consistent; do not set ConsistentRead to true.
• Use a key condition for the index partition key and optionally its sort key. Non-key conditions are filters applied after reading.
• Inspect write throttling and key violations if updates are not appearing as expected.

DynamoDB maintains index data automatically; applications do not write directly to the GSI. See a GSI query example and AWS index operations.