Skip to main content Skip to complementary content
Qlik Resources
Announcements
Search
Loading SearchUnify's search If you need assistance with your product, please contact Qlik Support.
Qlik Customer Portal

Writing the sample JSON documents to DynamoDB

Configure tFixedFlowInput to load the sample data in the data flow and configure tdynamoDBOutput to write this data in a DynamoDB table.

Procedure

  1. Double-click tFixedFlowInput in its Component view.

    Example

  2. Click the ... button next to Edit schema to open the schema editor.

    Example

  3. Click the + button twice to add two rows, each representing a column of the sample data, and in the Column column, name these columns to DeliveryId and EventPayload, respectively.
  4. On the row for the DeliveryId column, select the check box in the Key column to use this DeliveryID column as the partition key column of the DynamoDB table to be used. A DynamoDB table requires a partition key column.
  5. Click OK to validate these changes and once prompted, accept the propagation of the schema to the connected component, tdynamoDBOutput.
  6. In the Mode area, select the Use Inline content radio box and enter the sample data in the field that is displayed:

    Example

    21058;{"accountId" : "900" , "accountName" :  "xxxxx" , "action" : "Create", "customerOrderNumber" : { "deliveryCode" :  "261" , "deliveryId" :  "313"}}
21059;{"accountId" : "901" , "accountName" :  "xxxxy" , "action" : "Delete", "customerOrderNumber" : { "deliveryCode" :  "262" , "deliveryId" :  "314"}}
  7. Double-click tdynamoDBOutput to open its Component view.

    Example

  8. Click the ... button next to Edit schema to open the schema editor. This component should have retrieved the schema from tFixedFlowInput.
  9. In the Access key and Secret key fields, enter the credentials of the AWS account to be used to access your DynamoDB database.
  10. From the Region list, select the AWS region to be used. If you do not know which region to select, ask the administrator of your AWS system for more information.
  11. In the Table name field, enter the name to be used for the DynamoDB table to be created.
  12. From the Action on data drop-down list, select Insert.
  13. Select the Create table if does not exist check box.
  14. In the Partition Key field, enter the name of the column to be used to provide partition keys. In this example, it is DeliveryId.
  15. In the Partition Key type field, enter the data type of the partition key. In this example, it is String.

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – please let us know!

Leave your feedback here