How to create an Amazon DynamoDB table in Qlik Automate

[Andreas_Giesbrecht]

This article documents how to create an AWS Amazon DynamoDB table using Qlik Automate. The example automation is attached to this article and can be imported. See How to import and export automations for details.

1. Choose the Amazon DynamoDB Create Table block
   
   
   
   The Key Schema and Attribute Definitions input field cannot simply have a JSON structure applied (such as "[{'AttributeName': 'ID', 'KeyType': 'HASH'}]"). The key is to create variables and lists and apply these lists as inputs.
   
   
   • Key Schema example:
     
     First, create an AttributeName variable with the Key AttributeName and the Value ID
     
     
     
     
   • Repeat this for the KeyType variable with the Key KeyType and Value HASH.
     
     
     
     
2. Create a Variable List with the Variable keyList (list) and Item Key
   
   
   
   
3. Apply the Variable List to the Key Schema field:
   
   

The finished automation:

Notes:

• If the billing is PROVISIONED, the ProvisionedThroughput must explicitly include both ReadCapacityUnits and WriteCapacityUnits:
  

  "ProvisionedThroughput": {
    "ReadCapacityUnits": 5,
    "WriteCapacityUnits": 5}

• There is a known issue when using PAY_PER_REQUEST as the billing mode. This should be fixed in the next releases.

Environment

• Qlik Cloud Analytics
• Qlik Automate