Creating a new data model

To create a new data model

1. Open NoSQL Workbench, and in the navigation pane on the left side, choose the Data modeler icon.

   

2. Choose Create data model.

   

3. Enter a name, author and description for the data model, and then choose Create.

4. Choose Add table.

   

   For more information about tables, see Working with tables in DynamoDB.

5. Specify the following:

   • Table name — Enter a unique name for the table.

   • Partition key — Enter a partition key name and specify its type.

   • If you want to add a sort key:

     1. Select Add sort key.

     2. Specify the sort key name and its type.
   

6. To add other attributes, do the following for each attribute:

   1. Choose Add other attribute.

   2. Specify the attribute name and type.

   

7. Add a facet:

   Note

   Facets represent an application's different data access patterns for DynamoDB.

   • Select Add facets.

   • Choose Add facet.

     

   • Specify the following:

     • The Facet name.

     • A Partition key alias.

     • A Sort key alias.

     • Choose the Other attributes that are part of this facet.

   Choose Add facet.

   

   Repeat this step if you want to add more facets.

8. If you want to add a global secondary index, choose Add global secondary index.

   Specify the Global secondary index name, Partition key attribute, and Projection type.

   

   For more information about working with global secondary indexes in DynamoDB, see Global secondary indexes.

9. By default, your table will use provisioned capacity mode with auto scaling enabled on both read and write capacity. If you want to change these settings, uncheck "Default settings" under Capacity settings.

   

   Select your desired capacity mode, read and write capacity, and auto scaling IAM role (if applicable).

   

   For more information about DynamoDB capacity settings, see Read/write capacity mode.

10. Choose Add table definition.