Create a NoSQL Table

Let’s create a table in NoSQL. This table will be used to store the unstructured or semi-structured JSON data generated in the application through user inputs.

To create a NoSQL table:

1. Navigate to the Catalyst CloudScale service section in the console and click Start Exploring.
   

2. Navigate to the NoSQL component under STORAGE, and click Create Table.
   

3. Name your table “TaskHandler”.
   

4. Enter “UserID” as the Partition Key, and select String as the Data Type. You can use the UserID field to represent an individual who creates and manages their tasks. This should be kept unique for each user.
   

5. Select Yes to include Sort Key. Enter “TaskName” as the Sort Key, and select String as the Data Type.
   

6. Click Create.
   

The table will be created and a unique Table ID will be generated by Catalyst to refer to the table.

Configure Table Indexes

Next, we are going to configure indexes for the NoSQL table. Indexes are required to create other attributes that can be used to search for data stored in the table.

To create an Index:

1. Navigate to the Indexes tab, and click Add Index.
   

2. Enter “PrimaryIndex” as the name of the index.
   

3. Enter “UserID” as the name of the Partition Key and select String as the Data Type.
   

4. Select No, as no additional Sort Keys are required for the index, select All Attributes as the Attribute Type, and click Create.
   

The required index has been created.

The NoSQL component has been configured for the application.