Salesforce Input - PK Chunking

Question

Does the salesforce input tool somehow automatically use pk chunking in queries if over a certain limit?  There was an incident caused recently that used up a large number of batches when running queries that would otherwise be one batch.  It seemed to do this when the input tool hit 100k records.  No changes were done to the workflow.

I am trying to determine if this was done on the salesforce end, alteryx end or connector end.  Would anyone know anything about this?

eknudson · Accepted Answer

Thanks Andrew!  What I ended up learning is that in the odbc driver there is a pkchunking option which can be an issue for production as it can use up bulk api batches excessively.  Appreciate you sharing that info!