Bulk API 2.0 and Bulk API Developer Guide

Introduction to Bulk API 2.0 and Bulk API
What’s the Difference Between Bulk API 2.0 and Bulk API?
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 when you create a bulk query job and then add 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 7 days.

This flowchart depicts how bulk queries are processed.

How bulk queries are processed