In SFDC(salesforce) connector, we have partitioning mechanisms to split a giant query to multiple sub queries. There are 3 mechanisms:
- simple partition (equally split by time)
- dynamic pre-partition (generate histogram and split by row numbers)
- user specified partition (set up time range in job file)
However there are tables like Task and Contract are failing time to time to fetch full data.
We may want to utilize PK-chunking to partition the query.
The pk-chunking doc from SFDC - https://developer.salesforce.com/docs/atlas.en-us.api_asynch.meta/api_asynch/async_api_headers_enable_pk_chunking.htm