All Collections
Data Destinations
Getting Started with Amazon DynamoDB
Getting Started with Amazon DynamoDB

Set up a DynamoDB table and send your BitBrew data there.

B
Written by Ben Mills
Updated over a week ago

You can use our integration with AWS DynamoDB to send event to cloud storage.
​
​This guide will show you how to:

  1. Create a DynamoDB user (based on the AWS tutorial).

  2. Create a DynamoDB table.

  3. Link to your Dynamo table from the BitBrew Dashboard app.

If you don't already have one, you'll first need to create an AWS account.

Create a DynamoDB User

To follow AWS best practices, it's best to create a user that specifically manages your DynamoDB tables. To do so, navigate to Identity and Access Management (IAM) from the master menu.

In the Users tab of the IAM console, click the Add User button. 

On the create page, give the user a name and select 'Programmatic access' for access type. You can also optionally select 'Management Console access' and set a password if you want to log in to the AWS UI as this user. Then, click Next.

On the permissions page, choose to attach existing policies to this user directly, then scroll through the list and select AmazonDynamoDBFullAccesswithDataPipeline. Then, click Next.

Review the user details and click Create.

On the confirmation page, you'll receive the user's Access key ID and Secret access key. You'll need these credentials to authorize the BitBrew platform to write data to your DynamoDB table. Save these credentials in a secure place, since you won't be able to see the secret again.

Initiate DynamoDB

Now navigate to DynamoDB from the master menu.
​

Create a DynamoDB Table

On the home DynamoDB page, click Create table button.

If you are already using DynamoDB for other projects, click the Create table button on the DynamoDB console. 

On the create page, give your table a name.

Next, you'll need to input a partition key to help you sort the data you'll be sending to this table. We strongly recommend using eventId as the partition key, since it is a unique identifier. If you do not use a unique identifier as the partition key, events will be overwritten. We also suggest using deviceId as the sort key.


​
 Other column names that will appear in every event can also be used as your sort key:

  • receivedAt : (string) - An ISO 8601-formatted time stamp of when the platform received the event. Order is guaranteed.

  • tags : (list) - A list of tags that the device has been tagged with. 

  • triggeredRule: (string) - The name of the platform rule that captured this event.

  • deliveredAt : (string) - An ISO 8601-formatted time stamp of when the platform delivered this event to Dynamo. Order is not guaranteed.

After choosing your table settings, click Create.

Set Up DynamoDB Destination in the BitBrew Dashboard

Once you've created your table in AWS, log in to dashboard.bitbrew.com and click on the Destinations nav item. Then click into the "Amazon DynamoDB" tab and click the Add Destination button.

On the create page, input your AWS credentials and region information. Then, click the Verify button.

Once verified, select the DynamoDB table you created from the list, and select one of the following two formats for how the platform will write event data into your table:

  • Document

  • Columns

The document format means that, regardless of event type, the same  

Then, give your destination a name. This field is automatically populated from the name of your Dynamo table, but you can choose any name you'd like.

Finally, click Create. Your new Amazon DynamoDB destination will appear in the list view. 

Now that you have a destination set up, you'll need to write some rules and select this table as the destination for the output.

Did this answer your question?