---
title: "Insert Rows"
url: https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/data-store/insert-rows/
description: "This page describes the method to insert a single row or rows in bulk from a table in the Data Store in your Python application with sample code snippets."
last_updated: 2025-11-19T15:07:41Z
service: Cloud Scale
type: general
related_links:
  - name: "Insert Rows - API"
    url: /en/api/code-reference/cloud-scale/data-store/insert-new-row/#InsertNewRow
  - name: "Data Store Help"
    url: /en/cloud-scale/help/data-store/introduction
  - name: "SDK Scopes"
    url: /en/sdk/python/v1/sdk-scopes
---

# Insert Rows

You can insert a new row in a table in the [Catalyst Data Store](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/introduction) by referring to the table's unique ID or name. You can also insert multiple rows in a table as explained in the next section.

The `table_service` reference used in the code below can either be a table instance or table meta created earlier.

> **Note:**

* The table and the columns in it must already be created. You can [create a table](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/tables/#create-a-new-table) and [the columns for it](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/columns/#create-a-new-column) from the console.

* You will be able to insert upto 5000 records in each table per project in the
[development environment](https://docs.catalyst.zoho.com/en/deployment-and-billing/environments/development-environment). You can create upto 25,000 records overall in each project in the development environment. There are no upper limits for record creation in the production environment.

### Insert a Single Row

You must create a dictionary containing the row details in a  {column name : column value} format, and pass it as an argument to the `insert_row()` method, as shown below. This inserts the rows in the table that you refer by its unique tablename or tableID. 

A unique `ID` value for the row is automatically generated once the row is inserted. To know more about the [component instance](https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/data-store/get-component-instance/)`datastore_service` and the [table instance](https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/data-store/get-table-instance/)`table_service` used below, please refer to their respective help sections.

**Parameters Used**

<table class="content-table">
	<thead>
		<tr>
			<th class="w20p">Parameter Name</th>
      <th class="w20p">Data Type</th>
      <th class="w60p">Definition</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td>`row_data`</td>
      <td>Array</td>
			<td>A **Mandatory** parameter. Will hold the details of the row to be inserted in key-value pairs.</td>
		</tr>
	</tbody>
</table>

```python
#Insert a single row in the table
datastore_service = app.datastore()
table_service = datastore_service.table("Employee")
row_data = {'name': 'George Hamilton', 'id': '6868', 'age': '22'}
row_response = table_service.insert_row(row_data)

```

A sample response is shown below :

```javascript
{
  CREATORID: "2136000000006003",
  MODIFIEDTIME: "2021-08-16 16:30:12:799",
  Name: "George Hamilton",
  Age: 22,
  ID: 6868,
  CREATEDTIME: "2021-08-16 16:30:12:799",
  ROWID: "2136000000011015"
}

```

### Insert Multiple Rows

You can insert multiple rows in a table by constructing an array that contains the rows, and passing it as an argument
to the `insert_rows()` method as shown below. To know more about the [component instance](https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/data-store/get-component-instance/)`datastore_service` and the [table instance](https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/data-store/get-table-instance/)`table_service` used below, please refer to their respective help sections.

This returns a response containing an array of row objects.

**Parameters Used**

<table class="content-table">
	<thead>
		<tr>
			<th class="w20p">Parameter Name</th>
      <th class="w60p">Data Type</th>
      <th class="w60p">Definition</th>
		</tr>
	</thead>
	<tbody>
		<tr>
			<td>`row_data`</td>
      <td>Array</td>
			<td>A **Mandatory** parameter. Will hold the details of the rows to be inserted in key-value pairs.</td>
		</tr>
	</tbody>
</table>

```python
datastore_service = app.datastore()
table_service = datastore_service.table("Employee")
row_data = [{'name': 'Mark Wellington', 'id': '7218', 'age': '29'},
            {'name': 'Zendaya Jones', 'id': '3211', 'age': '32'}]
row_response = table_service.insert_rows(row_data)

```

A sample response is shown below :

```javascript
[
  {
    CREATORID: "2136000000006003",
    MODIFIEDTIME: "2021-08-25 13:55:04:904",
    Name: "Mark Wellington",
    Age: 29,
    ID: 7218,
    CREATEDTIME: "2021-08-25 13:55:04:904",
    ROWID: 2136000000011015
  },
  {
    CREATORID: "2136000000006003",
    MODIFIEDTIME: "2021-08-25 13:55:04:906",
    Name: "Zendaya Jones",
    Age: 32,
    ID: 3211,
    CREATEDTIME: "2021-08-25 13:55:04:906",
    ROWID: 2136000000011016
  }
]

```

> **Info :** Refer to the [SDK Scopes table](https://docs.catalyst.zoho.com/en/sdk/python/v1/sdk-scopes) to determine the required permission level for performing the above operation.