Enable Primary Key Chunking

EnablePKChunking

Key Name Default Value Required

EnablePKChunking

Selected (1)

No

Description

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 QueriesEnableBulkQuery option must be enabled.
  • The Enable Primary Key ChunkingEnablePKChunking option is enabled.
  • The number of results is greater than or equal to the value specified for the Bulk API Query At This Many RecordsBulkQueryThreshold option.
  • The number of results is greater than or equal to the value specified for the Primary Key Chunking At This Many RecordsPKChunkThreshold option.

The chunk size used is dependent on the Primary Key Chunk SizePKChunkSize setting.

Note:

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