Enable Primary Key Chunking

When this option is enabled (1), the connector attempts to use the Bulk API with primary key chunking enabled when retrieving data. If data retrieval fails, then the connector falls back to using the REST API to retrieve the data.

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.
  • 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. See Primary Key Chunking At This Many Records for more details.

The chunk size used is dependent on the Primary Key Chunk Size (PKChunkSize) setting. See Primary Key Chunk Size for more details.

Note:

This option is only available when the connector parses queries as SQL statements. For more information see Parse Method.

Key Name Default Value Required

EnablePKChunking

Selected (1)

No