Bulk Read Rows

Catalyst allows you to perform bulk read jobs on a specific table present in the Data Store.

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. The datastore_service reference used below is already defined in the component instance page.

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

    

        
copy
        

            

        
    
    

         #Bulk read
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'])