Bulk API 2.0 and Bulk API Developer Guide

Introduction to Bulk API 2.0
Getting Started
Bulk API 2.0
Bulk API
How Bulk API Works
Limits
Work with Jobs
Bulk API Ingest
Bulk API Query
How Bulk Queries Are Processed
Use Bulk Query
Walk Through a Bulk Query Sample
Walk Through a Bulk Query Sample Using PK Chunking
Sample Client Application Using Java
Map Data Fields
Bulk API End-of-Life
Glossary
PDF

Newer Version Available

This content describes an older version of this product. View Latest

How Bulk Queries Are Processed

The Bulk query workflow begins with creating a bulk query job, and then adding one or more batches to the query job. When a bulk query is processed, Salesforce attempts to execute the query. If the query doesn’t execute within the standard 2-minute timeout limit, the job fails and a QUERY_TIMEOUT error is returned. In this case, rewrite a simpler query and resubmit the batch.

If the query succeeds, Salesforce attempts to retrieve the results. If the results exceed the 1-GB file size limit or take longer than 10 minutes to retrieve, the completed results are cached and another attempt is made. After 15 attempts, the job fails and the error message “Retried more than fifteen times” is returned. In this case, consider using the PK Chunking header to split the query results into smaller chunks. If the attempts succeed, the results are returned and stored for seven days.

The following flowchart depicts how bulk queries are processed.

How bulk queries are processed