Connecting to live datasets
To connect to your Amazon DynamoDB tables with NoSQL Workbench, you must first connect to your AWS account.
To add a connection to your database
-
In NoSQL Workbench, in the navigation pane on the left side, choose the Operation builder icon.
-
Choose Add connection.
-
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:
-
-
Choose Connect.
If you don't want to sign up for a free tier account, and prefer to use DynamoDB local (downloadable version):
-
Choose the Local tab on the connection screen.
-
Specify the following information:
-
Connection name
-
Port
-
-
Choose the connect button.
-
-
On the created connection, choose Open.
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 run queries against the selected table.
To run queries on a table
-
In the Attribute name list, choose the attribute that you want to query on.
-
Specify the comparison operator.
-
Specify the data type of the value.
-
Specify the value to query for.
-
Choose Scan.
For more information about this operation, see Scan in the Amazon DynamoDB API Reference.