You are here: Pega Platform database > Database tables and columns > Property optimization > Database Column Population using the Column Populator

Database Column Population using the Column Populator

After adding a new column to a table schema, you can populate values for that new column by using the Database Column Populator or the service-enabled Column Populator.

Note: The Column Populator can only be used with Single Value properties.

For example, you can expose a Single Value property contained in the Storage Stream (BLOB) by adding a new column to the table. Columns can be added using the Property Optimization tool or Modify Schema wizard. New columns will contain values only for rows added or updated after that column was added. Use the Column Populator or the service-enabled Column Populator to copy the value for each existing row from the Storage Stream into the new column.

A single database table may contain rows from two or more concrete classes. The value in the pxObjClass column identifies the row's class. Rows corresponding to instances of classes not on the list are unaffected by this utility.

You can also rebuild database indexes, and Index- instances defined by Declare Index rules that are related to the database table, using the Column Populator.

If you expose a property and then populate the new column in a development system, repeat this process in the corresponding test and production systems, if such systems exist.

Prerequisites

Before you start the Database Column Populator, identify the PegaRULES database tables to be processed and all of the concrete classes that are mapped to those tables. You can use the Modify Schema Wizard to view the classes.