How to fix GlobalTableNotFoundException: Global Table not found in DynamoDB

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

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

# Check global table regions and replication status
aws dynamodb describe-global-table --global-table-name YourGlobalTableName \
  --query 'GlobalTableDescription.ReplicationGroup[*].{Region:RegionName,Status:ReplicationStatus}'

# Check if underlying table exists as regular table
aws dynamodb describe-table --table-name YourGlobalTableName

# Wait for global table to become active
while true; do
  status=$(aws dynamodb describe-global-table --global-table-name YourGlobalTableName \
    --query 'GlobalTableDescription.GlobalTableStatus' \
    --output text)
  if [ "$status" = "ACTIVE" ]; then
    echo "Global table is ACTIVE"
    break
  fi
  echo "Global table status: $status - waiting..."
  sleep 30
done

# Check replication status in all regions
aws dynamodb describe-global-table --global-table-name YourGlobalTableName \
  --query 'GlobalTableDescription.ReplicationGroup[*].{Region:RegionName,Status:ReplicationStatus}' \
  --output table

# Monitor creation progress
aws dynamodb describe-global-table-settings --global-table-name YourGlobalTableName

// AWS SDK v3 for JavaScript - global table operations
import { DynamoDBClient } from '@aws-sdk/client-dynamodb';
import { DescribeGlobalTableCommand } from '@aws-sdk/client-dynamodb';

const client = new DynamoDBClient({
  region: 'us-east-1', // Region where global table was created
  credentials: {
    accessKeyId: process.env.AWS_ACCESS_KEY_ID,
    secretAccessKey: process.env.AWS_SECRET_ACCESS_KEY,
  }
});

// Check global table existence
try {
  const command = new DescribeGlobalTableCommand({
    GlobalTableName: 'YourGlobalTableName'
  });
  const response = await client.send(command);
  console.log('Global table exists:', response.GlobalTableDescription);
} catch (error) {
  if (error.name === 'GlobalTableNotFoundException') {
    console.error('Global table not found');
    // Check if regular table exists first
    const regularTableExists = await checkRegularTable('YourGlobalTableName');
    if (regularTableExists) {
      console.log('Table exists but global tables not enabled');
    }
  }
}

// IAM permissions check for global table operations
// Required permissions: dynamodb:DescribeGlobalTable, dynamodb:UpdateGlobalTable, etc.

# First, ensure the base table exists
aws dynamodb create-table   --table-name YourGlobalTableName   --attribute-definitions AttributeName=id,AttributeType=S   --key-schema AttributeName=id,KeyType=HASH   --billing-mode PAY_PER_REQUEST

# Wait for table to become active
aws dynamodb wait table-exists --table-name YourGlobalTableName

# Create global table (enable multi-region replication)
aws dynamodb create-global-table   --global-table-name YourGlobalTableName   --replication-group RegionName=us-east-1

# Add additional regions if needed
aws dynamodb update-global-table   --global-table-name YourGlobalTableName   --replica-updates '{"Create": {"RegionName": "eu-west-1"}}'

# Verify global table creation
aws dynamodb describe-global-table --global-table-name YourGlobalTableName

# Check IAM permissions for the role/user
aws iam get-policy-version   --policy-arn arn:aws:iam::123456789012:policy/YourPolicyName   --version-id v1

# Simulate permissions for global table operations
aws iam simulate-principal-policy   --policy-source-arn arn:aws:iam::123456789012:role/YourRole   --action-names dynamodb:DescribeGlobalTable dynamodb:UpdateGlobalTable

# Search CloudTrail for global table operations
aws cloudtrail lookup-events   --lookup-attributes AttributeKey=EventName,AttributeValue=CreateGlobalTable   --start-time $(date -u -d '24 hours ago' +%s)   --end-time $(date -u +%s)   --query 'Events[?contains(CloudTrailEvent, "YourGlobalTableName")]'

# Check for DeleteGlobalTable events
aws cloudtrail lookup-events   --lookup-attributes AttributeKey=EventName,AttributeValue=DeleteGlobalTable   --start-time $(date -u -d '7 days ago' +%s)   --end-time $(date -u +%s)

async function ensureGlobalTableExists(globalTableName, regions) {
  try {
    const describeCommand = new DescribeGlobalTableCommand({
      GlobalTableName: globalTableName
    });
    const response = await dynamodbClient.send(describeCommand);

    // Check if all required regions are present
    const existingRegions = response.GlobalTableDescription.ReplicationGroup.map(r => r.RegionName);
    const missingRegions = regions.filter(region => !existingRegions.includes(region));

    if (missingRegions.length > 0) {
      console.log('Adding missing regions: ' + missingRegions.join(', '));
      await addRegionsToGlobalTable(globalTableName, missingRegions);
    }

    return response.GlobalTableDescription;
  } catch (error) {
    if (error.name === 'GlobalTableNotFoundException') {
      console.log('Global table ' + globalTableName + ' not found, creating...');

      // First ensure base table exists
      await ensureTableExists(globalTableName);

      // Create global table
      const createCommand = new CreateGlobalTableCommand({
        GlobalTableName: globalTableName,
        ReplicationGroup: regions.map(region => ({ RegionName: region }))
      });

      const createResponse = await dynamodbClient.send(createCommand);
      console.log('Global table ' + globalTableName + ' created');

      // Wait for active status
      await waitForGlobalTableActive(globalTableName);
      return createResponse.GlobalTableDescription;
    }
    throw error;
  }
}

async function waitForGlobalTableActive(globalTableName, maxWaitMinutes = 10) {
  const startTime = Date.now();

  while (Date.now() - startTime < maxWaitMinutes * 60 * 1000) {
    try {
      const command = new DescribeGlobalTableCommand({ GlobalTableName: globalTableName });
      const response = await dynamodbClient.send(command);

      if (response.GlobalTableDescription.GlobalTableStatus === 'ACTIVE') {
        console.log('Global table ' + globalTableName + ' is ACTIVE');
        return true;
      }

      console.log('Global table status: ' + response.GlobalTableDescription.GlobalTableStatus);
      await new Promise(resolve => setTimeout(resolve, 30000)); // Wait 30 seconds
    } catch (error) {
      console.error('Error checking global table status:', error);
      return false;
    }
  }

  throw new Error('Global table ' + globalTableName + ' did not become active within ' + maxWaitMinutes + ' minutes');
}