Primary Key Chunking At This Many Records

The number of query results at which the connector starts to use the Bulk API with primary key chunking for data retrieval.

The connector uses primary key chunking only when all of the following requirements are met:

  • The query can be executed with primary key chunking.
  • The Enable Bulk API Queries (EnableBulkQuery) option must be enabled. See Enable Bulk API Queries for more details.
  • The Enable Primary Key Chunking (EnablePKChunking) option is enabled. See Enable Primary Key Chunking for more details.
  • The number of results is greater than or equal to the value specified for the Bulk API Query At This Many Records (BulkQueryThreshold) option. See Bulk API Query At This Many Records for more details.
  • The number of results is greater than or equal to the value specified for the Primary Key Chunking At This Many Records (PKChunkThreshold) option.

If data retrieval fails, then the connector falls back to using the REST API to retrieve the data.

Key Name Default Value Required

PKChunkThreshold

100000

No