Exploring Datasets - Amazon DynamoDB

Exploring Datasets

To explore your Amazon DynamoDB tables, you first need to connect to your AWS account.

To add a connection to your database

  1. In NoSQL Workbench, in the navigation pane on the left side, choose the Operation builder icon.

                        Console screenshot showing the operation builder icon.
  2. Choose Add connection.

                        Console screenshot showing the add connection button.
  3. Specify the following information:

    • Account alias

    • AWS Region

    • Access key ID

    • Secret access key

    For more information about how to obtain the access keys, see Getting an AWS Access Key.

    You can optionally, specify the following:

  4. Choose Connect.

                        Console screenshot showing the connect button.

    If you don't want to sign up for a free tier account, and prefer to use DynamoDB Local (Downloadable Version):

    1. Choose the Local tab on the connection screen

    2. Specify the following information:

      • Connection name

      • Port

    3. Choose the connect button.

                                Console screenshot showing the Create table button.
  5. On the created connection, choose Open.

                        Console screenshot showing the open button.
    • When adding a connection to DynamoDB Local (Downloadable Version), NoSQL Workbench generates a random AWS access key ID and secret access key. To retrieve the values of these keys, choose View credentials from the connection context menu.

                                    Console screenshot showing the open button.
    • When adding a connection to DynamoDB Local (Downloadable Version), the NoSQL Workbench uses localhost as the Region for the DynamoDB Local connection.

    • If DynamoDB Local (Downloadable Version) is launched without the -sharedDb command line option, a new database file is created in DynamoDB Local for each connection from NoSQL Workbench.

    • You can't use an existing DynamoDB Local (Downloadable Version) database (created via AWS CLI/SDK) via NoSQL Workbench, unless the DynamoDB Local instance was started with the -sharedDb command line option.

After connecting to your DynamoDB database, the list of available tables appears in the left pane. Choose one of the tables to return a sample of the data stored in the table.

You can now execute queries against the selected table.

To execute queries on a table

  1. In the Attribute name list, choose the attribute that you want to query on.

  2. Specify the comparison operator.

  3. Specify the data type of the value.

  4. Specify the value to query for.

  5. Choose Scan.

                        Console screenshot showing the attribute dropdown list.

For more information about this operation, see Scan in the Amazon DynamoDB API Reference.

You can update and delete any row that is returned. To update, choose the Edit (pencil) icon on the right side of the row. To delete, choose the Delete (trash can) icon.

                Console screenshot showing the pencil and trash can icons.

Choosing the Delete icon starts a Delete Item operation.

                Console screenshot showing the DeleteItem operation builder.

Choosing the Edit icon starts an Update Item operation.

                Console screenshot showing the updateitem operation builder.

Choosing the + (plus sign) in the bottom left of the row list starts a Put Item operation.

                Console screenshot showing the putitem operation builder.