Enabling retrieval of the total record count for profiling (IBM Knowledge Catalog)

By default, the option to retrieve a data asset's total record count during profiling is disabled.

Provided the connector supports that type of query, the profiling service can retrieve the total record count for an asset. However, these queries can be costly. Therefore, if you want to make this information available in asset and column profiles, you must explicitly enable the option to retrieve the total record count. The option cannot be set per data source but is applied to all supported data sources when enabled.

Required permissions

You must be cluster administrator, an administrator of the project where the IBM Knowledge Catalog is installed, or a user with permission to run oc commands.

To enable queries for the total record count:

1. Log in to the cluster as a user with the appropriate permissions.

2. Set the wdp_profiling_load_record_count environment variable to true by running the following command:

   oc patch wkc wkc-cr  -n ${PROJECT_CPD_INST_OPERANDS} --type merge --patch '{"spec": {"wdp_profiling_load_record_count": true}}'