How to connect your AWS DynamoDB with Rocketadmin

This user guide outlines the procedure for establishing a Rocketadmin connection to an AWS DynamoDB database.

note

The instructions are general and do not contain any detailed explanations on specific AWS features. To learn the fundamentals, find best practices and experience the full AWS potential, please visit https://docs.aws.amazon.com/.

AWS settings

Create DynamoDB table

1. Sign in to your AWS account.

2. From the Dashboard enter DynamoDB in the Search field:

   

3. Click on DynamoDB.

4. In the next screen click on Create table:

   ---

   

   ---

5. Fill in the following information:

   • Table name
   • Partition key
   • (optionally) Sort key

   ---

   

   ---

6. Select Default or Customized settings based on your preferences:

   ---

   

   ---

7. You can optionally add tags:

   

8. Click on Create table.

9. Wait a few moments until the table status becomes Active:

   ---

   

   ---

   
   

Add items to the table

1. In the table's Actions menu click on Create item:

   ---

   

   ---

2. Add some items, for example:

   ---

   

   ---

   

Manage table access

Table permissions

1. In order to grant access to the table, navigate to the Permissions tab:

   ---

   

   ---

2. Click on Create table policy.

3. In the resource-based policy screen click on Add new statement:

   ---

   

   ---

4. Select some actions, for example, Scan, Query, PutItem, UpdateItem:

   ---

   

   ---

5. Click on Create policy. Your settings are applied.

User permissions and credentials

1. From the Dashboard enter IAM (Identity and Access Management) in the Search field:

   

2. Click on IAM.

3. Choose the Users menu and click on your username:

   ---

   

   ---

4. In the Permissions tab expand the Add permissions menu and click on Add permissions:

   ---

   

5. In the next screen leave the preset option Add user to group and click on Create group:

   ---

   

   ---

6. Enter a meaningful name to identify the group:

   ---

   

   ---

7. Search for suitable DynamoDB policies and highlight those that align with your needs:

   ---

   

   ---

8. Click on Create user group.

9. Mark the group and click on Next:

   ---

   

   ---

10. Review the settings and click on Add permissions:

    ---

    

    ---

    The policies are updated:

    ---

    

    ---

11. Navigate to the Security credentials tab and scroll down to the Access keys section:

    ---

    

    ---

12. Click on Create access key.

13. Select the option Other and click on Next:

    ---

    

    ---

14. Review the best practices suggested by Amazon and click on Next:

    ---

    

    ---

15. You can optionally add a description tag:

    ---

    

    ---

16. Click on Create access key.

17. In the next screen you have the opportunity to copy and/or download your Access key and Secret access key. Please note that this is the only time these keys can be viewed and downloaded:

    ---

    

    ---

18. Click on Done to complete the action. The new access key appears in the Security credentials tab:

    ---

    

Rocketadmin settings

The final steps of this guide include creating a Rocketadmin connection to the AWS DynamoDB and reviewing the data in the table. Follow the guidelines:

1. Sign in to your Rocketadmin account.

2. In the Dashboard click on Add database:

   ---

   

   ---

3. In the Connect a database screen:

   • enter a name for the connection

   • select DynamoDB as database type

     ---

     

     ---

4. Enter the following information in the connection's details:

   • Hostname: the endpoint matching your database region. For the full list of Amazon endpoints, please visit https://docs.aws.amazon.com/general/latest/gr/ddb.html#ddb_region

   • Username: your Access key

   • Password: your Secret access key

     ---

     

     ---

5. Click on Test connection.

6. Once the connection is successful, click on Add.

Your table appears in the Dashboard:

---

---