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?
Solved! Go to Solution.
@eknudson , there was recently a new version of the Salesforce connector released. see the link to download below.
https://community.alteryx.com/t5/Community-Gallery/Salesforce-Input-Tool/ta-p/877898
Try this one out and if it resolves your issue, please mark this repy as the solution so that others in the Community can benefit from our collaboration.
Thanks!
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!