# Exploring datasets and building operations with NoSQL Workbench
<a name="workbench.querybuilder"></a>

NoSQL Workbench for Amazon DynamoDB provides a rich graphical user interface for developing and testing queries. You can use the operation builder in NoSQL Workbench to view, explore, and query live datasets. The structured operation builder supports projection expression, condition expression, and generates sample code in multiple languages. You can directly clone tables from one Amazon DynamoDB account to another one in different Regions. You can also directly clone tables between DynamoDB local and an Amazon DynamoDB account for faster copying of your table’s key schema (and optionally GSI schema and items) between your development environments.You can save as many as 50 DynamoDB data operations in the operation builder.

**Topics**
+ [

# Connecting to live datasets
](workbench.querybuilder.connect.md)
+ [

# Building complex operations
](workbench.querybuilder.operationbuilder.md)
+ [

# Cloning tables with NoSQL Workbench
](workbench.querybuilder.cloning-tables.md)
+ [

# Exporting data to a CSV file
](workbench.querybuilder.exportcsv.md)

# Connecting to live datasets
<a name="workbench.querybuilder.connect"></a>

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**

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

1. Choose **Add connection**.

1. Specify the following information:
   + **Connection name**
   + **AWS Region**
   + **Access key ID**
   + **Secret access key**

   For more information about how to obtain the access keys, see [Getting an AWS access key](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/SettingUp.DynamoWebService.html#SettingUp.DynamoWebService.GetCredentials).

   You can optionally, specify the following:
   + [https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_temp_use-resources.html](https://docs.aws.amazon.com/IAM/latest/UserGuide/id_credentials_temp_use-resources.html)
   + [https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_identifiers.html#identifiers-arns](https://docs.aws.amazon.com/IAM/latest/UserGuide/reference_identifiers.html#identifiers-arns)

1. Choose **Connect**.

    If you don't want to sign up for a free tier account, and prefer to use [ DynamoDB local (downloadable version)](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/DynamoDBLocal.html): 

   1. Choose the **Local** tab on the connection screen.

   1. Specify the following information:
      + **Connection name**
      + **Port**

   1. Choose the **connect** button.
**Note**  
To connect to DynamoDB local, either manually launch DynamoDB local using your terminal (see [deploying DynamoDB local on your computer](DynamoDBLocal.DownloadingAndRunning.md)) or launch DynamoDB local directly using the DDB local toggle in the NoSQL Workbench navigation menu. Ensure the connection port is the same as your DynamoDB local port.

1. 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, see the next section on building operations see [Building complex operations](workbench.querybuilder.operationbuilder.md).

# Building complex operations
<a name="workbench.querybuilder.operationbuilder"></a>

The operation builder in NoSQL Workbench for Amazon DynamoDB provides a visual interface where you can perform complex data plane operations. It includes support for projection expressions and condition expressions. Once you've built an operation, you can save it for later use (up to 50 operations can be saved). You can then browse a list of your frequently used data-plane operations in the **Saved Operations** menu, and use them to automatically populate and build a new operation. You can also generate sample code for these operations, in multiple languages.

NoSQL Workbench supports building [PartiQL](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.html) for DynamoDB statements, which allows you to interact with DynamoDB using a SQL-compatible query language. NoSQL Workbench also supports building DynamoDB CRUD API operations.

To use NoSQL Workbench to build operations, in the navigation pane on the left side, choose the **Operation builder** icon.

**Topics**
+ [

# Building PartiQL statements
](workbench.querybuilder.partiql.md)
+ [

# Building API operations
](workbench.querybuilder.operationbuilder.api.md)

# Building PartiQL statements
<a name="workbench.querybuilder.partiql"></a>

To use NoSQL Workbench to build [PartiQL for DynamoDB](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.html) statements, choose **PartiQL editor** near the top of the NoSQL Workbench UI.

You can build the following PartiQL statement types in the operation builder.

**Topics**
+ [

## Singleton statements
](#workbench.querybuilder.partiql.single)
+ [

## Transactions
](#workbench.querybuilder.partiql.transaction)
+ [

## Batch
](#workbench.querybuilder.partiql.batch)

## Singleton statements
<a name="workbench.querybuilder.partiql.single"></a>

To run or generate code for a PartiQL statement, do the following.

1. Choose **PartiQL editor** near the top of the window.

1. Enter a valid [PartiQL statement](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.statements.html).

1. If your statement uses parameters:

   1. Choose **Optional request parameters**.

   1. Choose **Add new parameters**.

   1. Enter the attribute type and value.

   1. If you want to add additional parameters, repeat steps b and c.

1. If you want to generate code, choose **Generate code**.

   Select your desired language from the displayed tabs. You can now copy this code and use it in your application.

1. If you want the operation to be run immediately, choose **Run**.

1. If you want to save this operation for later use, choose **Save operation**. Then enter a name for your operation and choose **Save**.

## Transactions
<a name="workbench.querybuilder.partiql.transaction"></a>

To run or generate code for a PartiQL transaction, do the following.

1. Choose **PartiQLTransaction** from the **More operations** dropdown.

1. Choose **Add a new statement**.

1. Enter a valid [PartiQL statement](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.statements.html).
**Note**  
Read and write operations are not supported in the same PartiQL transaction request. A SELECT statement cannot be in the same request with INSERT, UPDATE, and DELETE statements. See [Performing transactions with PartiQL for DynamoDB](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.multiplestatements.transactions.html) for more details.

1. If your statement uses parameters

   1. Choose **Optional request parameters**.

   1. Choose **Add new parameters**.

   1. Enter the attribute type and value.

   1. If you want to add additional parameters, repeat steps b and c.

1. If you want to add more statements, repeat steps 2 to 4.

1. If you want to generate code, choose **Generate code**.

   Select your desired language from the displayed tabs. You can now copy this code and use it in your application.

1. If you want the operation to be run immediately, choose **Run**.

1. If you want to save this operation for later use, choose **Save operation**. Then enter a name for your operation and choose **Save**.

## Batch
<a name="workbench.querybuilder.partiql.batch"></a>

To run or generate code for a PartiQL batch, do the following.

1. Choose **PartiQLBatch** from the **More operations** dropdown.

1. Choose **Add a new statement**.

1. Enter a valid [PartiQL statement](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.statements.html).
**Note**  
 Read and write operations are not supported in the same PartiQL batch request, which means a SELECT statement cannot be in the same request with INSERT, UPDATE, and DELETE statements. Write operations to the same item are not allowed. As with the BatchGetItem operation, only singleton read operations are supported. Scan and query operations are not supported. See [Running batch operations with PartiQL for DynamoDB](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/ql-reference.multiplestatements.batching.html) for more details.

1. If your statement uses parameters:

   1. Choose **Optional request parameters**.

   1. Choose **Add new parameters**.

   1. Enter the attribute type and value.

   1. If you want to add additional parameters, repeat steps b and c.

1. If you want to add more statements, repeat steps 2 to 4.

1. If you want to generate code, choose **Generate code**.

   Select your desired language from the displayed tabs. You can now copy this code and use it in your application.

1. If you want the operation to be run immediately, choose **Run**.

1. If you want to save this operation for later use, choose **Save operation**. Then enter a name for your operation and choose **Save**.

# Building API operations
<a name="workbench.querybuilder.operationbuilder.api"></a>

To use NoSQL Workbench to build DynamoDB CRUD APIs, select **Operation builder** from the left of the NoSQL Workbench user interface.

Then select **Open** and choose a connection.

You can perform the following operations in the operation builder.
+ [Delete Table](#workbench.querybuilder.operationbuilder.DeleteTable)
+ [Create Table](#workbench.querybuilder.operationbuilder.CreateTable)
+ [Update Table](#workbench.querybuilder.operationbuilder.UpdateTable)
+ [Put Item](#workbench.querybuilder.operationbuilder.Put)
+ [Update Item](#workbench.querybuilder.operationbuilder.update)
+ [Delete Item](#workbench.querybuilder.operationbuilder.Delete)
+ [Query](#workbench.querybuilder.operationbuilder.Query)
+ [Scan](#workbench.querybuilder.operationbuilder.scan)
+ [Transact Get Items](#workbench.querybuilder.operationbuilder.transactget)
+ [Transact Write Items](#workbench.querybuilder.operationbuilder.transactwrite)

## Delete table
<a name="workbench.querybuilder.operationbuilder.DeleteTable"></a>

To run a `Delete Table` operation, do the following.

1. Find the table you want to delete from the **Tables** section.

1. Select **Delete Table** from the horizontal ellipsis menu.

1. Confirm you want to delete the table by entering the **Table name**.

1. Select **Delete**.

For more information about this operation, see [Delete table](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_DeleteTable.html) in the *Amazon DynamoDB API Reference*. 

## Delete GSI
<a name="workbench.querybuilder.operationbuilder.DeleteGSI"></a>

To run a `Delete GSI` operation, do the following.

1. Find the GSI of a table you want to delete from the **Tables** section.

1. Select **Delete GSI** from the horizontal ellipsis menu.

1. Confirm you want to delete the GSI by entering the **GSI name**.

1. Select **Delete**.

For more information about this operation, see [Delete table](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_DeleteTable.html) in the *Amazon DynamoDB API Reference*. 

## Create table
<a name="workbench.querybuilder.operationbuilder.CreateTable"></a>

To run a `Create Table` operation, do the following.

1. Choose the **\$1** icon next to the **Tables** section.

1. Enter the table name desired.

1. Create a partition key.

1. Optional: create a sort key.

1. To customize capacity settings, and uncheck the box next to **Use default capacity settings**.
   + You can now select either **Provisioned** or **On-demand capacity.**

     With Provisioned selected, you can set minimum and maximum read and write capacity units. You can also enable or disable auto scaling.
   + If the table is currently set to On-demand, you will be unable to specify a provisioned throughput.
   + If you switch from On-demand to Provisioned throughput, then Autoscaling will automatically be applied to all GSIs with: min: 1, max: 10; target: 70%.

1. Select **Skip GSIs and create** to create this table without a GSI. Optionally, you can select **Next** to create a GSI with this new table.

For more information about this operation, see [Create table](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_CreateTable.html) in the *Amazon DynamoDB API Reference*. 

## Create GSI
<a name="workbench.querybuilder.operationbuilder.CreateGSI"></a>

To run a `Create GSI` operation, do the following.

1. Find a table that you want to add a GSI to.

1. From the horizontal ellipsis menu, select **Create GSI**.

1. Name your GSI under **Index name**.

1. Create a partition key.

1. Optional: create a sort key.

1. Choose a projection type option from the dropdown.

1. Select **Create GSI**.

For more information about this operation, see [Create table](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_CreateTable.html) in the *Amazon DynamoDB API Reference*. 

## Update table
<a name="workbench.querybuilder.operationbuilder.UpdateTable"></a>

To update capacity settings for a table with an `Update Table` operation, do the following.

1. Find the table you want to update capacity settings for.

1. From the horizontal ellipsis menu, select **Update capacity settings**.

1. Select either **Provisioned** or **On-demand capacity.**

   With **Provisioned** selected, you can set minimum and maximum read and write capacity units. You can also enable or disable auto scaling.

1. Select **Update**.

For more information about this operation, see [Update table](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_UpdateTable.html) in the *Amazon DynamoDB API Reference*.

## Update GSI
<a name="workbench.querybuilder.operationbuilder.UpdateGSI"></a>

To update capacity settings for a GSI with an `Update Table` operation, do the following.

**Note**  
By default, global secondary indexes inherit the capacity settings of the base table. Global secondary indexes can have a different capacity mode only when the base table is in provisioned capacity mode. When you create a global secondary index on a provisioned mode table, you must specify read and write capacity units for the expected workload on that index. For more information, see [Provisioned throughput considerations for Global Secondary Indexes](GSI.md#GSI.ThroughputConsiderations).

1. Find the GSI you want to update capacity settings for.

1. From the horizontal ellipsis menu, select **Update capacity settings**.

1. You can now select either **Provisioned** or **On-demand capacity.**

   With **Provisioned** selected, you can set minimum and maximum read and write capacity units. You can also enable or disable auto scaling.

1. Select **Update**.

For more information about this operation, see [Update table](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_UpdateTable.html) in the *Amazon DynamoDB API Reference*.

## Put item
<a name="workbench.querybuilder.operationbuilder.Put"></a>

You create an item by using the `Put Item` operation. To run or generate code for a `Put Item` operation, do the following.

1. Find the table you want to create an item in.

1. From the **Actions** dropdown, select **Create item**.

1. Enter the partition key value.

1. Enter the sort key value, if one exists.

1. If you want to add non-key attributes, do the following:

   1. Select **\$1 Add other attributes**.

   1. Specify the **Attribute name**, **Type**, and **Value**. 

1. If a condition expression must be satisfied for the `Put Item` operation to succeed, do the following:

   1. Choose **Condition**.

   1. Specify the attribute name, comparison operator, attribute type, and attribute value.

   1. If other conditions are needed, choose **Condition** again.

   For more information, see [DynamoDB condition expression CLI example](Expressions.ConditionExpressions.md).

1. If you want to generate code, choose **Generate code**.

   Select your desired language from the displayed tabs. You can now copy this code and use it in your application.

1. If you want the operation to be run immediately, choose **Run**.

1. If you want to save this operation for later use, choose **Save operation**, then enter a name for your operation and choose **Save**.

For more information about this operation, see [PutItem](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_PutItem.html) in the *Amazon DynamoDB API Reference*. 

## Update item
<a name="workbench.querybuilder.operationbuilder.update"></a>

To run or generate code for an `Update Item` operation, do the following:

1. Find the table you want to update an item in.

1. Select the item.

1. Enter the attribute name and attribute value for the selected expression.

1. If you want to add more expressions, choose another expression in the **Update Expression** dropdown list, and then select the **\$1** icon.

1. If a condition expression must be satisfied for the `Update Item` operation to succeed, do the following:

   1. Choose **Condition**.

   1. Specify the attribute name, comparison operator, attribute type, and attribute value.

   1. If other conditions are needed, choose **Condition** again.

   For more information, see [DynamoDB condition expression CLI example](Expressions.ConditionExpressions.md).

1. If you want to generate code, choose **Generate code**.

   Choose the tab for the language that you want. You can now copy this code and use it in your application.

1. If you want the operation to be run immediately, choose **Run**.

1. If you want to save this operation for later use, choose **Save operation**, then enter a name for your operation and choose **Save**.

For more information about this operation, see [UpdateItem](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_UpdateItem.html) in the *Amazon DynamoDB API Reference*. 

## Delete item
<a name="workbench.querybuilder.operationbuilder.Delete"></a>

To run a `Delete Item` operation, do the following.

1. Find the table you want to delete an item in. 

1. Select the item.

1. From the **Actions** dropdown, select **Delete item**.

1. Confirm you want to delete the item by selecting **Delete**.

For more information about this operation, see [DeleteItem](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_DeleteItem.html) in the *Amazon DynamoDB API Reference*.

## Duplicate item
<a name="workbench.querybuilder.operationbuilder.Duplicate"></a>

You can duplicate an item by creating a new item with the same attributes. To duplicate an item, do the following.

1. Find the table you want to duplicate an item in.

1. Select the item.

1. From the **Actions** dropdown, select **Duplicate item**.

1. Specify a new partition key.

1. Specify a new sort key (if necessary).

1. Select **Run**.

For more information about this operation, see [DeleteItem](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_DeleteItem.html) in the *Amazon DynamoDB API Reference*.

## Query
<a name="workbench.querybuilder.operationbuilder.Query"></a>

To run or generate code for a `Query` operation, do the following.

1. Select **Query** from the top of the NoSQL Workbench UI.

1. Specify the partition key value.

1. If a sort key is needed for the `Query` operation:

   1. Select **Sort key**.

   1. Specify the comparison operator, and attribute value.

1. Select **Query** to run this query operation. If more options are needed, check the **More options** checkbox and continue on with the following steps.

1. If not all the attributes should be returned with the operation result, select **Projection expression**.

1. Choose the **\$1** icon.

1. Enter the attribute to return with the query result.

1. If more attributes are needed, choose the **\$1 **.

1. If a condition expression must be satisfied for the `Query` operation to succeed, do the following:

   1. Choose **Condition**.

   1. Specify the attribute name, comparison operator, attribute type, and attribute value.

   1. If other conditions are needed, choose **Condition** again.

   For more information, see [DynamoDB condition expression CLI example](Expressions.ConditionExpressions.md).

1. If you want to generate code, choose **Generate code**.

   Choose the tab for the language that you want. You can now copy this code and use it in your application.

1. If you want the operation to be run immediately, choose **Run**.

1. If you want to save this operation for later use, choose **Save operation**, then enter a name for your operation and choose **Save**.

For more information about this operation, see [Query](https://docs.aws.amazon.com/amazondynamodb/latest/APIReference/API_Query.html) in the *Amazon DynamoDB API Reference*. 

## Scan
<a name="workbench.querybuilder.operationbuilder.scan"></a>

To run or generate code for a `Scan` operation, do the following.

1. Select **Scan** from the top of the NoSQL Workbench UI.

1. Select the **Scan** button to perform this basic scan operation. If more options are needed, check the **More options** checkbox and continue on with the following steps.

1. Specify an attribute name to filter your scan results.

1. If not all the attributes should be returned with the operation result, select **Projection expression**.

1. If a condition expression must be satisfied for the scan operation to succeed, do the following:

   1. Choose **Condition**.

   1. Specify the attribute name, comparison operator, attribute type, and attribute value.

   1. If other conditions are needed, choose **Condition** again. 

   For more information, see [DynamoDB condition expression CLI example](Expressions.ConditionExpressions.md).

1. If you want to generate code, choose **Generate code**.

   Choose the tab for the language that you want. You can now copy this code and use it in your application.

1. If you want the operation to be run immediately, choose **Run**.

1. If you want to save this operation for later use, choose **Save operation**, then enter a name for your operation and choose **Save**.

## TransactGetItems
<a name="workbench.querybuilder.operationbuilder.transactget"></a>

To run or generate code for a `TransactGetItems` operation, do the following.

1. From the **More operations** dropdown at the top of the NoSQL Workbench UI, choose **TransactGetItems**.

1. Choose the **\$1** icon near **TransactGetItem**.

1. Specify a partition key.

1. Specify a sort key (if necessary).

1. Select **Run** to perform the operation, **Save operation** to save it, or **Generate code** to generate code for it.

For more information about transactions, see [Amazon DynamoDB transactions](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/transactions.html).

## TransactWriteItems
<a name="workbench.querybuilder.operationbuilder.transactwrite"></a>

To run or generate code for a `TransactWriteItems` operation, do the following.

1. From the **More operations** dropdown at the top of the NoSQL Workbench UI, choose **TransactWriteItems**.

1. Choose an operation from the **Actions** dropdown.

1. Choose the **\$1** icon near **TransactWriteItem**.

1. In the **Actions** dropdown, choose the operation that you want to perform.
   + For `DeleteItem`, follow the instructions for the [Delete item](#workbench.querybuilder.operationbuilder.Delete) operation. 
   + For `PutItem`, follow the instructions for the [Put item](#workbench.querybuilder.operationbuilder.Put) operation. 
   + For `UpdateItem`, follow the instructions for the [Update item](#workbench.querybuilder.operationbuilder.update) operation.

   To change the order of actions, choose an action in the list on the left side, and then choose the up or down arrows to move it up or down in the list. 

   To delete an action, choose the action in the list, and then choose the **Delete** (trash can) icon. 

1. Select **Run** to perform the operation, **Save operation** to save it, or **Generate code** to generate code for it.

For more information about transactions, see [Amazon DynamoDB transactions](https://docs.aws.amazon.com/amazondynamodb/latest/developerguide/transactions.html).

# Cloning tables with NoSQL Workbench
<a name="workbench.querybuilder.cloning-tables"></a>

Cloning tables will copy a table’s key schema (and optionally GSI schema and items) between your development environments. You can clone a table between DynamoDB local to an Amazon DynamoDB account, and even clone a table from one account to another in different Regions for faster experimentation.

**To clone a table**

1. In the **Operation Builder**, select your connection and Region (Region selection is not available for DynamoDB local).

1. Once you are connected to DynamoDB, browse your tables and select the table you want to clone.

1. From the horizontal ellipsis menu, select the **Clone** option.

1. Input your clone destination details:

   1. Select a connection.

   1. Select a Region (Region is not available for DynamoDB local).

   1. Enter a new table name.

   1. Choose a clone option:

      1. **Key schema** is selected by default and cannot be unselected. By default, cloning a table will copy your primary key and sort key if they are available.

      1. **GSI schema** is selected by default if your table to be cloned has a GSI. Cloning a table will copy your GSI primary key and sort key if they are available. You have the option to deselect GSI schema to skip cloning the GSI schema. Cloning a table will copy your base table’s capacity settings as the GSI’s capacity settings. You can use the `UpdateTable` operation in Operation Builder to update the table’s GSI capacity setting after cloning is complete.

1. Enter the number of items to clone. To only clone the key schema and optionally the GSI schema, you can keep the **Items to clone** value at 0. The maximum number of items that can be cloned is 5000.

1. Choose a capacity mode:

   1. **On-demand mode** is selected by default. DynamoDB on-demand offers pay-per-request pricing for read and write requests so that you pay only for what you use. To learn more, see [DynamoDB On-demand mode](capacity-mode.md#capacity-mode-on-demand) .

   1. **Provisioned mode** lets you specify the number of reads and writes per second that you require for your application. You can use auto scaling to adjust your table’s provisioned capacity automatically in response to traffic changes. To learn more, see [DynamoDB Provisioned mode](provisioned-capacity-mode.md).

1. Select **Clone** to begin cloning.

1. The cloning process will run in the background. The **Operation builder** tab will show a notification when there is a change in the cloning table status. You can access this status by selecting the **Operation builder** tab and then selecting the arrow button. The arrow button is located on the cloning table status widget located near the bottom of the menu sidebar.

# Exporting data to a CSV file
<a name="workbench.querybuilder.exportcsv"></a>

You can export the results of a query from Operation Builder to a CSV file. This enables you to load the data into a spreadsheet or process it using your preferred programming language.

**Exporting to CSV**

1. In the Operation Builder, run an operation of your choice, such as a Scan or Query.
**Note**  
You can only export results from read API operations and PartiQL statements to a CSV file. You can't export results from transaction read statements.
Currently, you can export results one page at a time to a CSV file. If there are multiple pages of results, you must export each page individually.

1. Select the items you want to export from the results.

1. In the **Actions** dropdown, choose **Export as CSV**.

1. Choose a filename and location for your CSV file and select **Save**.