dynamodb_table_gsi.py

import boto3

dynamodb = boto3.resource("dynamodb")

params = {
    "TableName": "customer_purchase_ts",
        "KeySchema": [
            {"AttributeName": "customer_id", "KeyType": "HASH"}
        ],
        "LocalSecondaryIndexes": [
            {
                "IndexName": "feature_time_series",
                "KeySchema": [
                    {"AttributeName": "customer_id", "KeyType": "HASH"},
                    {"AttributeName": "transaction_date_epoch", "KeyType": "RANGE"}
                ],
                "Projection": {
                    "ProjectionType": "ALL"
                },
            }
        ],
      "GlobalSecondaryIndexes": [
            {
                "IndexName": "purchase_category",
                "KeySchema": [
                    {"AttributeName": "category_name", "KeyType": "HASH"},
                    {"AttributeName": "customer_id", "KeyType": "RANGE"}
                ],
                "Projection": {
                    "ProjectionType": "KEYS_ONLY"
                },
            }
        ],
        "AttributeDefinitions": [
            {"AttributeName": "customer_id", "AttributeType": "S"},
            {"AttributeName": "category_name", "AttributeType": "S"},
            {"AttributeName": "transaction_date_epoch", "AttributeType": "N"},
        ],
    #Other settings...
}
}

table = dynamodb.create_table(**params)