---
title: "Add and Manage Data"
url: https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/working-with-data/add-manage-data/
description: "Catalyst NoSQL is a fully-managed, powerful database that provides you with a non-relational, non-SQL means of data storage. Create, manage, and query data in NoSQL tables with ease, and perform CRUD operations in Java, Node.js, and Python."
last_updated: 2026-08-17T12:16:04Z
service: Cloud Scale
type: general
---

# Add and Manage Data in a NoSQL Table

### Overview

This section covers performing CRUD operations in Catalyst NoSQL, as well as managing data from the Catalyst console. Refer to the [Java](https://docs.catalyst.zoho.com/en/sdk/java/v1/cloud-scale/nosql/get-table-metadata/), [Node.js](https://docs.catalyst.zoho.com/en/sdk/nodejs/v2/cloud-scale/nosql/get-component-instance/), and [Python](https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/nosql/get-component-instance/) SDK and the [API documentation](https://docs.catalyst.zoho.com/en/api/code-reference/cloud-scale/nosql/insert-item/#InsertNewItem) for performing data operations through code or API.

Here are a few points to remember when you add or update data in a Catalyst NoSQL table:

* The values for the configured partition key of a table must be present in each data item, if it is configured with a simple primary key. In case of a composite primary key, both [partition key and sort key](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/components/#table-keys) values must be present in each data item.

* The data types configured for the partition key and sort key of a table must match with the data types you provide for the values of those attributes.

* You will not be able to change the data types of the partition key and sort key in a table or the attributes associated with them, when you add or update data in the table.

* The maximum total size of an item provisioned in Catalyst NoSQL is 400 KB.

### Add Data in a Table

To add data in a NoSQL table from the Catalyst console to test:

1. Navigate to the *Data* section of the table from the NoSQL component, then click **Add Data**.

![nosql_add_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_add_data_1.webp)

2. This will open a pop-up where you can add data to the table. Catalyst will display a template for the data, which will include the partition key and sort key configured for the table, in both the [Custom and Standard JSON formats](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/working-with-data/introduction/#the-catalyst-custom-json-format).

> **Note:** You can only add one item in the table from the console. This is because, the data operations provided in the console are solely for testing purposes.

![nosql_add_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_add_data_2.webp)

You can switch between the standard and Custom JSON view using the toggle button. However, there are certain conditions that data in the standard format must satisfy for you to be able to switch to the Custom format. This is explained below.

![nosql_add_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_add_data_3.webp)

3. Add the data for the table in either of the formats, then click **Create**.
	
**Custom JSON Format:**

![nosql_add_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_add_data_4.webp)

**Standard JSON Format:**

![nosql_add_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_add_data_5.webp)

#### Conditions when the JSON View Toggle Button is Disabled

In certain cases, you will not be able to toggle between the Standard and the Custom JSON format while adding or updating data in the console. These include:

1. When the data type of an attribute is invalid or not [supported](https://docs.catalyst.zoho.com/en/cloud-scale/help/nosql/working-with-data/introduction/#supported-data-types) in Catalyst

2. When the value provided for a key in the JSON is invalid

3. When the JSON code added is invalid, or contains syntax or logical errors

4. When the data is valid but includes certain supported data types that cannot be rendered in the Standard JSON view. For example, SS (Set of Strings) or SN (Set of Numbers) cannot be rendered, but the data you provide will be added to the table.

After you add the data in a NoSQL table, it will be displayed in the Data section in a tabular manner for easy viewing.

![nosql_data_added](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_added.webp)

> **Note:** Please remember that the table data will not be displayed persistently in the *Data* section. You will be able to view the table data only by querying in this section.

You can filter columns to be displayed upon querying or right after adding data through the console, using the **Filter icon** in the bottom-right corner. Select the required columns and click **Apply**.

![nosql_data_filters](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_filter_columns.webp)

This will display the selected columns.

![nosql_data_filters](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_filter_columns_2.webp)

#### View Table Data as JSON

1. You can view the table data in the JSON format by clicking the ellipsis icon against the table.

![nosql_json_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_ellipsis.webp)

2. Then, click **View JSON** from the options.

![nosql_json_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_view_json_1.webp)

This displays the table data in Catalyst Custom JSON format.

![nosql_json_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_view_json_2.webp)

### Update Data in a Table

You can update your NoSQL table data easily from the console to test. All the specifications and constraints described for data addition apply to the data update operation as well. 

> **Note:** If you update the data in a table from the console, it will essentially overwrite the existing data, as this is for testing purposes. However, if you update data from code through the SDKs, or through the API, the standard update process of a CRUD operation is applied.

To update the data of a NoSQL table in your project:

1. Click the ellipsis icon against the table, then click **Edit**.

![nosql_edit_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_edit_1.webp)

2. Update the data in the Standard or the Custom JSON format, then click **Update**.

![nosql_edit_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_edit_2.webp)

### Delete Data in a Table

To permanently delete the data you added in a NoSQL table for testing purposes:

1. Click the ellipsis icon against the table, then click **Delete**.

![nosql_delete_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_delete_1.webp)

2. Click **Delete** in the confirmation pop-up.

![nosql_delete_data](https://catalyst-docs-development.zohostratus.in/images/help/nosql/nosql_data_delete_2.webp)