How to create an Amazon DynamoDB table in Qlik Automate

Andreas_Giesbrecht — Wed, 02 Jul 2025 08:37:34 GMT

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.

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.
Create a Variable List with the Variable keyList (list) and Item Key
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

article How to create an Amazon DynamoDB table in Qlik Automate in Official Support Articles

How to create an Amazon DynamoDB table in Qlik Automate

Environment