Specifies whether formula fields should be excluded when listing columns for Certinia objects.

Data Type

bool

Default Value

false

Remarks

Formula fields in Certinia are calculated fields based on other field values. While they are useful for reporting and data transformations within Certinia, they may not always be necessary for external querying or data loads.

When SkipFormulaFields is set to true, the connector excludes all formula fields from the schema when listing available columns. This can simplify the schema and reduce clutter for users who do not need these fields in queries.

Excluding formula fields can speed up schema discovery and reduce the number of columns returned in metadata queries, especially in objects that have many formula fields. However, if reporting or queries rely on formula values, skipping these fields could limit functionality and available data in query results.

This property is useful for organizations looking to streamline their data model, improve metadata loading times, or focus only on directly stored data fields.