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.

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

    

        
copy
        

            

        
    
    

         // bulk read
const bulkRead = dataStore.table('sampleTable').bulkJob('read');

// create bulk read job
 const bulkReadJob = await bulkRead.createJob({
  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
await bulkRead.getStatus(bulkReadJob.job_id);

// Get bulk read result
await bulkRead.getResult(bulkReadJob.job_id);