---
title: "Bulk Read Rows"
url: https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/data-store/bulk-read-rows/
description: "This page describes the method to read rows in bulk from a table in the Data Store in your Python application with sample code snippets."
last_updated: 2025-03-28T12:54:49Z
service: Cloud Scale
type: general
related_links:
  - name: "Data Store Help"
    url: /en/cloud-scale/help/data-store/introduction
  - name: "SDK Scopes"
    url: /en/sdk/python/v1/sdk-scopes
---

# Bulk Read Rows

Catalyst allows you to perform bulk read jobs on a specific table present in the [Data Store](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/introduction). 

In the SDK snippet below, the Bulk Read job can read thousands of records from a specific table and generate a CSV file containing the results of the read operation, if the job is successful.The table is referred to by its unique [`Table ID`](https://docs.catalyst.zoho.com/en/cloud-scale/help/data-store/tables/). 

To know more about the component instance `datastore_service` used below, please refer to [this help section](https://docs.catalyst.zoho.com/en/sdk/python/v1/cloud-scale/data-store/get-component-instance/).

<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>`criteria`</td>
            <td>Array</td>
			<td>A **Mandatory** parameter. Will hold the conditions based on which the rows has to be read.</td>
		</tr>
        <tr>
			<td>`page`</td>
            <td>Numeric</td>
			<td>A **Mandatory** parameter. Will hold the number of page rows that has to be read.</td>
		</tr>
        <tr>
			<td>`select_columns`</td>
            <td>Array</td>
			<td>A **Mandatory** parameter. Will hold specific columns that has to be read.</td>
		</tr>
	</tbody>
</table>

Copy the SDK snippet below to perform a bulk read job on a particular table.

```python
#Bulk read
datastore_service = app.datastore()
bulk_read = datastore_service.table("sampleTable").bulk_read()
#Create bulk read job
bulk_read_Job = bulk_read.create_job({
            "criteria": {
                    "group_operator": 'or',
                    "group": [
                    {
                        "column_name": 'Department',
                        "comparator": 'equal',
                        "value": 'Marketing'
                    },
                    {
                        "column_name": 'EmpId',
                        "comparator": 'greater_than',
                        "value": '1000'
                    },
                    {
                        "column_name": 'EmpName',
                        "comparator": 'starts_with',
                        "value": 'S'
                    }
                    ]
            },
            "page": 1,
            "select_columns": ['EmpId', 'EmpName', 'Department']
 })
#Get bulk read status
status = bulk_read.get_status(bulk_read_Job['job_id']) 
#Get bulk read result
result = bulk_read.get_result(bulk_read_Job['job_id'])

```

> **Note:** A maximum of **200,000 rows** can be read simultaneously.

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