AWS DynamoDB

Amazon DynamoDB is a fully managed, serverless, key-value NoSQL database. UI Bakery allows you to easily connect to DynamoDB with no need for additional layers like APIs or third-party services.

Configuration

Prerequisites

To connect your DynamoDB to UI Bakery, start with creating a uibakery_dynamodb user in IAM:

• Enable programmatic access.

• You can grant full DynamoDB permissions or add the restrictions if required.

• Create a new policy and attach it to the new user.

Connecting the data source

Once you've created the user with all the necessary permissions, you can proceed to connecting your AWS DynamoDB data source to UI Bakery.

1. On the Data sources page, click Connect, and select AWS DynamoDB in the Data sources list.

2. Specify all the required credentials.

3. Click Test connection to check whether the data source can be connected, and then click Connect Datasource to complete the setup.

Usage

Once you've connected your data source, you can start writing queries to DynamoDB. For this purpose, you need to select the DynamoDB Request action type, select one of the predefined DynamoDB commands, and start constructing your queries in JS mode.

DynamoDB query examples

query

query is used to search for or filter the items in your DynamoDB collection. Select query from the list and specify its parameters:

{
  TableName: 'users',
  KeyConditionExpression: "Id = :v1",
  ExpressionAttributeValues: {
    ':v1': {"N": '101'},
  }
}

scan

scan is used to retrieve all of the items or just some of them from your DynamoDB collection. Select scan from the list and specify the query parameters:

{
	TableName: 'users',
}

getItem

The getItem operation returns a set of Attributes for an item that matches the primary key. Select getItem from the list and specify the query parameters:

{
  TableName: 'users',
  Key: {
    Id: {
      N: '101'
    }
  }
}

putItem

To add a new item to your collection, use putItem. Select putItem from the list and specify the query parameters:

{
  "TableName": "users",
  "Item": {
    "Id": {
        "N": "110"
    },
    "username": {
        "S": "JohnDoe"
    },
    "email": {
        "S": "[e-mail]"
    },
    "age": {
        "N": "30"
    },
    "gender": {
        "S": "male"
    }
  }
}

updateItem

updateItem edits an existing item's attributes or adds a new item to the table if it doesn't exist yet. You can put, delete, or add attribute values. Select updateItem from the list and specify the query parameters:

{
  "TableName": "users",
  "Key": {
    "Id": {
      "N": "101"
    }
  },
  "UpdateExpression": "SET Title = :title",
  "ExpressionAttributeValues": {
    ":title": {
      "S": {{ui.input.value}}
    }
  }
}

deleteItem

To delete an item from the collection, use deleteItem. Select deleteItem from the list and specify the query parameters:

{
  "TableName": "users",
  "Key": {
    "Id": {
      "N": "101"
    }
  }

batchWriteItem

To put or delete multiple items in one or more collections, use batchWriteItem. Select batchWriteItem from the list and specify the query parameters:

{
  "RequestItems": {
    "users": [
      {
        "PutRequest": {
          "Item": {
            "Id": {
              "N": "110"
            },
            "username": {
              "S": "JohnDoe"
            },
            "email": {
              "S": "[e-mail]"
            },
            "age": {
              "N": "30"
            },
            "gender": {
              "S": "male"
            }
          }
        }
      }
    ]
  }
}

For more details about DynamoDB queries, please refer to DynamoDB docs.

DynamoDB request