Phillip Ninan's Blog

Using NoSQL Workbench for a Local DynamoDb

Using NoSQL Workbench for a Local DynamoDb

Phillip Ninan's photo
Phillip Ninan
·

2 min read

In my previous tutorial, I taught you how to use Docker to spin up a local DynamoDb. Using a local DynamoDb can be tricky to manage because there is no default utility to manage the database tables. Today, I am going to show you use to use AWS NoSQL Workbench to manage your local DynamoDb.

Prerequisite

Download and install AWS NoSQL Workbench.

Using NoSQL Workbench

  1. Add a new database connection. Screen Shot 2021-01-25 at 12.14.24 AM.png

  2. Click "Data Modeler". Then let's create a data model for the database. Screen Shot 2021-01-25 at 12.15.39 AM.png

  3. Create a table. Screen Shot 2021-01-25 at 12.16.23 AM.png

  4. Click "Visualize data model". Screen Shot 2021-01-25 at 12.16.51 AM 2.png

  5. Commit the model to your local database. Screen Shot 2021-01-25 at 12.17.12 AM.png Screen Shot 2021-01-25 at 12.17.27 AM.png

  6. Open the connection to your local database. Screen Shot 2021-01-25 at 12.18.31 AM 2.png

  7. Add data to your table. Screen Shot 2021-01-25 at 12.19.49 AM 2.png Screen Shot 2021-01-25 at 12.20.12 AM.png Screen Shot 2021-01-25 at 12.20.32 AM.png

  8. That's it! Scan your new table. Screen Shot 2021-01-25 at 12.37.02 AM.png

Conclusion

This should be enough information to get you started! You can toy around with adding data and preparing queries. This is a very useful tool for modeling your data and creating indexes. I will be preparing more tutorials coming soon! Enjoy -- Cheers!

Did you find this article valuable?

Support Phillip Ninan by becoming a sponsor. Any amount is appreciated!

AWSDynamoDBNoSQL