Amazon DynamoDB独自のJSONデータ型「データ型記述子」についてまとめてみた

{
 "companyId": "COMP123",
 "userId": "USER456",
 "address": {
  "city": "Anytown",
  "state": "CA",
  "street": "123 Main St",
  "zipCode": "12345"
 },
 "age": 30,
 "departments": [
  "HR",
  "Finance"
 ],
 "email": "john.doe@example.com",
 "firstName": "John",
 "isActive": true,
 "lastLogin": "2023-05-15T14:30:00Z",
 "lastName": "Doe",
 "projects": [
  "Project A",
  "Project B",
  "Project C"
 ],
 "salary": 75000.5
}

{
 "companyId": {
  "S": "COMP123"
 },
 "userId": {
  "S": "USER456"
 },
 "address": {
  "M": {
   "city": {
    "S": "Anytown"
   },
   "state": {
    "S": "CA"
   },
   "street": {
    "S": "123 Main St"
   },
   "zipCode": {
    "S": "12345"
   }
  }
 },
 "age": {
  "N": "30"
 },
 "departments": {
  "L": [
   {
    "S": "HR"
   },
   {
    "S": "Finance"
   }
  ]
 },
 "email": {
  "S": "john.doe@example.com"
 },
 "firstName": {
  "S": "John"
 },
 "isActive": {
  "BOOL": true
 },
 "lastLogin": {
  "S": "2023-05-15T14:30:00Z"
 },
 "lastName": {
  "S": "Doe"
 },
 "projects": {
  "L": [
   {
    "S": "Project A"
   },
   {
    "S": "Project B"
   },
   {
    "S": "Project C"
   }
  ]
 },
 "salary": {
  "N": "75000.5"
 }
}

$ aws dynamodb scan --table-name aws-test-dynamodb-table
{
    "Items": [
        {
            "companyId": {
                "S": "COMP123"
            },
            "lastName": {
                "S": "Doe"
            },

            ...

            "age": {
                "N": "30"
            }
        }
    ],
    "Count": 1,
    "ScannedCount": 1,
    "ConsumedCapacity": null
}

import boto3
import json

def scan_and_display_dynamodb_item():
    # DynamoDBクライアントを作成
    dynamodb = boto3.client("dynamodb")

    # テーブルをスキャン
    response = dynamodb.scan(
        TableName="aws-test-dynamodb-table",
        Limit=1
    )

    # 結果を取得
    items = response.get("Items",[])
    print("Item found in the table:")
    item = items[0]
    print(item)

scan_and_display_dynamodb_item()

$ python3 sample.py 
Item found in the table:
{'companyId': {'S': 'COMP123'}, 'lastName': {'S': 'Doe'}, 'projects': {'L': [{'S': 'Project A'}, {'S': 'Project B'}, {'S': 'Project C'}]}, 'salary': {'N': '75000.5'}, 'address': {'M': {'zipCode': {'S': '12345'}, 'state': {'S': 'CA'}, 'city': {'S': 'Anytown'}, 'street': {'S': '123 Main St'}}}, 'departments': {'L': [{'S': 'HR'}, {'S': 'Finance'}]}, 'email': {'S': 'john.doe@example.com'}, 'firstName': {'S': 'John'}, 'lastLogin': {'S': '2023-05-15T14:30:00Z'}, 'isActive': {'BOOL': True}, 'userId': {'S': 'USER456'}, 'binary': {'B': b'\x00\x00'}, 'age': {'N': '30'}}