Amazon DynamoDB

• Purpose: Connect to an AWS DynamoDB table for NoSQL key-value and document data analysis.
• When to use it: Ideal for analyzing user events, session data, or any data stored in DynamoDB’s flexible schema.
• How to create it:
  1. Go to Data Sources and click Add.
  2. Select DynamoDB.
  3. Name: Enter a unique name for this connection.
  4. Region: AWS region where the table lives (e.g., us-east-1).
  5. Access Key ID: Your AWS IAM access key.
  6. Secret Access Key: The corresponding secret key.
  7. Table Name: The DynamoDB table to scan.
  8. Scan Limit: Maximum items to read per query (default 10,000).
  9. Endpoint URL: (Optional) Custom endpoint for local DynamoDB or VPC endpoints.
  10. Click Test Connection to verify, then Save.

Note: The IAM user must have at least dynamodb:Scan and dynamodb:DescribeTable permissions on the target table.