How to fix ResourceNotFoundException: Requested resource not found in DynamoDB

# List all tables in the region
aws dynamodb list-tables

# Describe a specific table to check its status
aws dynamodb describe-table --table-name YourTableName

# Check table status (should be ACTIVE)
aws dynamodb describe-table --table-name YourTableName \
  --query 'Table.TableStatus'

# For cross-account access, verify the full ARN
aws dynamodb describe-table --table-arn 'arn:aws:dynamodb:us-east-1:123456789012:table/YourTableName'

# Check all indexes on a table
aws dynamodb describe-table --table-name YourTableName \
  --query 'Table.GlobalSecondaryIndexes[*].{IndexName:IndexName,Status:IndexStatus}'

# Check specific index status
aws dynamodb describe-table --table-name YourTableName \
  --query "Table.GlobalSecondaryIndexes[?IndexName=='YourIndexName'].IndexStatus"

# Wait for index to become ACTIVE
while true; do
  status=$(aws dynamodb describe-table --table-name YourTableName \
    --query "Table.GlobalSecondaryIndexes[?IndexName=='YourIndexName'].IndexStatus" \
    --output text)
  if [ "$status" = "ACTIVE" ]; then
    echo "Index is ACTIVE"
    break
  fi
  echo "Index status: $status - waiting..."
  sleep 10
done

// AWS SDK v3 for JavaScript - check region configuration
import { DynamoDBClient } from '@aws-sdk/client-dynamodb';

const client = new DynamoDBClient({
  region: 'us-east-1', // Must match table region
  credentials: {
    accessKeyId: process.env.AWS_ACCESS_KEY_ID,
    secretAccessKey: process.env.AWS_SECRET_ACCESS_KEY,
    sessionToken: process.env.AWS_SESSION_TOKEN // For temporary credentials
  }
});

// For cross-account access, verify assumed role permissions
const stsClient = new STSClient({ region: 'us-east-1' });
const identity = await stsClient.send(new GetCallerIdentityCommand({}));
console.log('Current AWS account:', identity.Account);

// Environment variable check
console.log('AWS Region:', process.env.AWS_REGION);
console.log('AWS Default Region:', process.env.AWS_DEFAULT_REGION);

async function ensureTableExists(tableName, createTableParams) {
  try {
    await dynamodb.describeTable({ TableName: tableName }).promise();
    console.log('Table ' + tableName + ' exists');
    return true;
  } catch (error) {
    if (error.name === 'ResourceNotFoundException') {
      console.log('Table ' + tableName + ' not found, creating...');
      try {
        await dynamodb.createTable(createTableParams).promise();
        console.log('Table ' + tableName + ' created successfully');

        // Wait for table to become active
        await dynamodb.waitFor('tableExists', { TableName: tableName }).promise();
        return true;
      } catch (createError) {
        console.error('Failed to create table ' + tableName + ':', createError);
        return false;
      }
    }
    throw error;
  }
}

// For index-dependent operations
async function waitForIndexActive(tableName, indexName, maxWaitSeconds = 300) {
  const startTime = Date.now();

  while (Date.now() - startTime < maxWaitSeconds * 1000) {
    try {
      const data = await dynamodb.describeTable({ TableName: tableName }).promise();
      const index = data.Table.GlobalSecondaryIndexes?.find(idx => idx.IndexName === indexName);

      if (index?.IndexStatus === 'ACTIVE') {
        console.log('Index ' + indexName + ' is ACTIVE');
        return true;
      }

      console.log('Index ' + indexName + ' status: ' + (index?.IndexStatus || 'NOT_FOUND'));
      await new Promise(resolve => setTimeout(resolve, 5000)); // Wait 5 seconds
    } catch (error) {
      console.error('Error checking index status:', error);
      return false;
    }
  }

  throw new Error('Index ' + indexName + ' did not become active within ' + maxWaitSeconds + ' seconds');
}

# Search CloudTrail for recent DescribeTable failures
aws cloudtrail lookup-events \
  --lookup-attributes AttributeKey=EventName,AttributeValue=DescribeTable \
  --start-time $(date -u -d '1 hour ago' +%s) \
  --end-time $(date -u +%s) \
  --query 'Events[?contains(CloudTrailEvent, "ResourceNotFoundException")]'

# Check CloudWatch metrics for table operations
aws cloudwatch get-metric-statistics \
  --namespace AWS/DynamoDB \
  --metric-name UserErrors \
  --dimensions Name=TableName,Value=YourTableName \
  --start-time $(date -u -d '1 hour ago' +%s) \
  --end-time $(date -u +%s) \
  --period 300 \
  --statistics Sum

# Check if table was recently deleted
aws cloudtrail lookup-events \
  --lookup-attributes AttributeKey=EventName,AttributeValue=DeleteTable \
  --start-time $(date -u -d '24 hours ago' +%s) \
  --end-time $(date -u +%s) \
  --query 'Events[?contains(CloudTrailEvent, "YourTableName")]'

# CloudFormation example - check table name references
Resources:
  MyDynamoDBTable:
    Type: AWS::DynamoDB::Table
    Properties:
      TableName: MyApplicationTable  # This name must match application code
      BillingMode: PAY_PER_REQUEST
      AttributeDefinitions:
        - AttributeName: id
          AttributeType: S
      KeySchema:
        - AttributeName: id
          KeyType: HASH

  # Reference in other resources must use correct name
  MyLambdaFunction:
    Type: AWS::Lambda::Function
    Properties:
      Environment:
        Variables:
          TABLE_NAME: !Ref MyDynamoDBTable  # Passes logical ID, not table name
          # Should be: TABLE_NAME: MyApplicationTable

// AWS CDK TypeScript - common issues
import * as dynamodb from 'aws-cdk-lib/aws-dynamodb';

const table = new dynamodb.Table(this, 'MyTable', {
  tableName: 'my-application-table', // Explicit name
  partitionKey: { name: 'id', type: dynamodb.AttributeType.STRING },
  billingMode: dynamodb.BillingMode.PAY_PER_REQUEST,
});

// Common mistake: using logical ID instead of table name
const wrongTableName = table.tableName; // Returns 'my-application-table'
const logicalId = table.node.id; // Returns 'MyTable' - NOT the table name

// Pass correct name to Lambda environment
lambdaFunction.addEnvironment('TABLE_NAME', table.tableName);