Amazon DynamoDB Connector

Create, update, fetch, or delete items in an Amazon (AWS) DynamoDB database

Connections

AWS Role ARN

Connect to AWS using an assumed role

To enable the IAM role authentication begin by logging into the AWS Console and navigate to Identity and Access Management (IAM).

To create an ARN user and generate credentials:

1. Navigate to Users and select Create User.

• Provide a User name and check the box providing them user access to the AWS Management Console if needed.
• Once completed with the User creation, copy the ARN provided in the summary for a later step.

2. To obtain the ARN for an existing User, click on the designated username from the Users page and the ARN will be provided in the summary section.
3. From the summary section, select Create access key

• Select Third-party service as the access key type and select next.
• Set a description and select create access key.
• Copy the Access Key and Secret access key and enter those into the connection configuration of your integration along with the ARN.

To create and assign a user a role:

1. Navigate to Roles and select Create Role.

• Select Custom Trust Policy for the Trusted entity types
• Copy the following statement into the statement console. Making sure to replace the ARN with the user's actual ARN from the previous section

{
  "Version": "2012-10-17",
  "Statement": [
    {
      "Effect": "Allow",
      "Principal": {
        "AWS": "ARN"
      },
      "Action": "sts:AssumeRole"
    }
  ]
}

• When adding permissions provide the AmazonDynamoDBFullAccess permission
• Complete remaining steps and select Create Role

Input	Comments	Default
Role ARN	An AWS IAM Role ARN
Access Key ID	An AWS IAM Access Key ID
Secret Access Key	An AWS IAM Secret Access Key
External ID	Provides enhanced security measures to the connection. Optional, but recommended. Please check AWS docs for more information.

DynamoDB Access Key and Secret

Authenticates requests to Amazon DynamoDB using an API Key and API Secret.

An AWS IAM access key pair is required to interact with Amazon DynamoDB. Make sure that the key pair you generate in AWS has proper permissions to the DynamoDB resources you want to access. Read more about DynamoDB IAM actions in the AWS docs.

Input	Comments	Default
Access Key ID	An AWS IAM Access Key ID
Secret Access Key	An AWS IAM Secret Access Key

Actions

Create Table

Create a new DynamoDB Table

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Table Name	Provide the name of the table you would like to interact with.
Attribute Definition	For each list item, provide a javascript object containing an attribute name, and an attribute type. The attribute type must be in the format that DynamoDB uses: N = number, S = string, L = Array etc...	[ { "AttributeName": "customerId", "AttributeType": "N" }, { "AttributeName": "customerName", "AttributeType": "S" } ]
Key Schema	For each list item, provide a javascript object containing an attribute name, and a key type. The key type can either be a HASH or a RANGE key.	[ { "KeyType": "HASH", "AttributeName": "customerId" }, { "KeyType": "RANGE", "AttributeName": "customerName" } ]
Billing Mode	Select the item that represents your desired billing mode.	PROVISIONED
Read Capacity Units	One read capacity unit represents one strongly consistent read per second, or two eventually consistent reads per second, for an item up to 4 KB in size.	5
Write Capacity Units	One write capacity unit represents one write per second for an item up to 1 KB in size. If you need to write an item that is larger than 1 KB, DynamoDB must consume additional write capacity units.	5
Connection

Delete Item

Delete an item from a DynamoDB database

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Table Name	Provide the name of the table you would like to interact with.
Hash / Primary Key Value	The value of the hash key (primary key) to match
Range / Sort Key Value	The value of the optional range key (sort key) to match. This is required if your table has a range key.
Condition Expression
Expression Attribute Values	Expression attribute values in Amazon DynamoDB are substitutes for the actual values that you want to compare—values that you might not know until runtime. An expression attribute value must begin with a colon (:) and be followed by one or more alphanumeric characters.
Expression Attribute Value Types	The DynamoDB data type for each query param. You must specify a type for each Expression Attribute Value you provided.
Connection

Delete Table

Delete an existing DynamoDB Table

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Table Name	Provide the name of the table you would like to interact with.
Connection

Describe Table

Fetch metadata about an existing DynamoDB Table

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Table Name	Provide the name of the table you would like to interact with.
Connection

Get Item

Retrieve an item from a DynamoDB database

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Table Name	Provide the name of the table you would like to interact with.
Hash / Primary Key Value	The value of the hash key (primary key) to match
Range / Sort Key Value	The value of the optional range key (sort key) to match. This is required if your table has a range key.
Connection

List Tables

List all DynamoDB Tables

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Connection

Query Items

Query a DynamoDB table

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Table Name	Provide the name of the table you would like to interact with.
Expression Attribute Values	Expression attribute values in Amazon DynamoDB are substitutes for the actual values that you want to compare—values that you might not know until runtime. An expression attribute value must begin with a colon (:) and be followed by one or more alphanumeric characters.
Expression Attribute Value Types	The DynamoDB data type for each query param. You must specify a type for each Expression Attribute Value you provided.
Key Condition Expression	The key condition expression for the query.
Filter Expression	The filter expression for the query.
Query Parameters	The DynamoDB data type for each query param. You must specify a type for each Expression Attribute Value you provided.
Debug	Enable debug mode to log additional information.	false
Connection

Raw Request

Execute single PartiQL statements.

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Statement	The PartiQL statement representing the operation to run.
Parameters	The parameters for the PartiQL statement, if any.	[ "Rose" ]
Query Parameters	The DynamoDB data type for each query param. You must specify a type for each Expression Attribute Value you provided.
Debug	Enable debug mode to log additional information.	false
Connection

Update Item

Update an existing item in a DynamoDB database

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Table Name	Provide the name of the table you would like to interact with.
Hash / Primary Key Value	The value of the hash key (primary key) to match
Range / Sort Key Value	The value of the optional range key (sort key) to match. This is required if your table has a range key.
Update Expression	An update expression specifies how UpdateItem will modify the attributes of an item. For example, setting a scalar value or removing elements from a list or a map.
Condition Expression
Expression Attribute Values	Expression attribute values in Amazon DynamoDB are substitutes for the actual values that you want to compare—values that you might not know until runtime. An expression attribute value must begin with a colon (:) and be followed by one or more alphanumeric characters.
Expression Attribute Value Types	The DynamoDB data type for each query param. You must specify a type for each Expression Attribute Value you provided.
Connection

Upsert Item

Creates a new item, or replaces an existing item with a new item

Input	Comments	Default
AWS Region	AWS provides services in multiple regions, like us-west-2 or eu-west-1.
Table Name	Provide the name of the table you would like to interact with.
Value	Provide a key value record to be inserted into the specified table.
Value Types	For each item in the list, provide the datatype corresponding to the input item.
Condition Expression
Expression Attribute Values	Expression attribute values in Amazon DynamoDB are substitutes for the actual values that you want to compare—values that you might not know until runtime. An expression attribute value must begin with a colon (:) and be followed by one or more alphanumeric characters.
Expression Attribute Value Types	The DynamoDB data type for each query param. You must specify a type for each Expression Attribute Value you provided.
Connection