Microsoft Purview / Data Quality / Reference snapshot

Data quality functions: catalogue and editor checks

Every function entry in the inspected Purview ADF/DSL client registry, with an original description, category, evidence, confidence rating and client-validation result. Snapshot: 16 September 2026. Client build: 1.20260904.925.

Updated 24 September 2026: a visible example for each of the 259 functions. The registry snapshot and validation evidence remain dated 16 September; this documentation update did not run new scans.

259client registry entries
253representative probes accepted by client
6functions returned client diagnostics
0paid scans or runtime evaluations
This is a complete inventory of the inspected client registry, not a promise that all 259 functions run in Purview. The registry contains 193 General, 40 Aggregate and 7 Window entries; 19 entries omit functionType. Fifteen entries conflict with Purview's explicit support exclusions. The remaining 244 are not a verified runtime-supported count. An authenticated call to the documented Get Rules API succeeded, but that API returns configured asset rules, not a global function dictionary.

No-scan validation results

All 259 functions were exercised through the same parser/type-validator module used by the Purview expression editor. This was a direct, in-browser invocation of modelMarkerResolver, not 259 manual UI interactions. No rules were saved, no test assets were created, and no scans or server-side evaluations were started. Completed at 2026-09-16T11:28:08.822Z (UTC).

253 functions: at least one representative Boolean row probe returned no error diagnostics. Six functions: the validator reported unknown function for byItem, byName, byNames, byOrigin, byOrigins and byPath. This records client behavior for these probes; it does not establish server rejection in every context.

Context matters: the standalone expression null() received a null-value diagnostic, but its Boolean wrapper was accepted. Therefore the accepted count refers to the row probes, not to every standalone expression. Standalone diagnostics are also retained per row; 252 standalone probes had no error diagnostics.

mapLoop: mapLoop(3, #index * 2) raised a type diagnostic. mapLoop(3, toInteger(#index) * 2) was accepted; both attempts are retained. Six follow-up diagnostic probes were performed, in addition to the primary cases.

Important contradiction: all 15 functions explicitly excluded by the Purview documentation also passed these client checks. They remain marked Explicitly unsupported. Editor acceptance does not override the product support documentation.

Method, synthetic schema and validator controls

The synthetic schema was n: integer; x: double; y: double; s: string; flag: boolean; d: date; ts: timestamp. These were in-memory column definitions, not a dataset stored in Purview. Each function was checked both as an expression and inside n >= 0 && !isNull(expression), with a Boolean return-type requirement. This wrapper tests parser/type acceptance and includes a column reference; it is not a recommended business rule or a test of the function's returned value.

Seven controls checked the validator itself: a valid Boolean predicate, an unknown function, a wrong argument type, a missing argument, an unclosed expression, an unknown column, and a non-Boolean row expression. All produced their expected acceptance/error outcome. Exact diagnostics are stored per row as resource IDs and parameters, avoiding invented translations.

One representative expression is not exhaustive overload coverage. These checks do not prove correct output values, null behavior, numerical precision, timezone handling, aggregate/window execution, source compatibility, or scan-time availability. Description-confidence ratings were deliberately not upgraded merely because the parser accepted an expression.

Full structured synthetic test evidence is embedded in this file in the validation-evidence JSON element. No credentials or customer data are included.

How the categories relate

The linked Purview page lists rule families, not mutually exclusive categories for every expression function. Most functions below are building blocks inside Custom rules. like and regexMatch also implement String format match approaches. The table preserves the literal client functionType separately from a more useful editorial functional group.

Accuracy, Completeness, Conformity, Consistency, Timeliness and Uniqueness are quality dimensions. Their assignment depends on the purpose of a rule; it would be misleading to assign each function to exactly one of them.

Rule familyDescriptionImportant behaviorDescription confidence
FreshnessChecks whether an asset was updated within an expected interval.Uses last-modified information; score is pass/fail (100 or 0). Source support restrictions apply.High
Unique valuesChecks that individual column values are unique.Null/empty treatment depends on whether an Empty/blank fields rule is defined.High
String format matchValidates against allowed values, a LIKE pattern or a regular expression.Enumeration is configuration, not a separate DSL function. Null/empty handling depends on the blank-field rule.High
Data type matchChecks values against the rule engine's expected datatype.Uses the ADF-derived type system rather than source-native SQL type names.High
Duplicate rowsChecks uniqueness of a combination of column values.The documentation permits at most one instance per asset.High
Empty/blank fieldsRequires populated values; strings must not be empty or whitespace-only.This is stricter than notNull(), which permits an empty string.High
Table lookupChecks values against a reference asset's column.The reference must belong to the same governance domain; this rule is not the excluded ADF cached-lookup function family.High
Custom (ADF/DSL)Combines expression functions into a Boolean validation rule.Supports row, optional filter and null-handling expressions. This is the scope of the 259-function inventory below.High
Custom (SQL)Uses Spark SQL predicates for custom validation.Documented separately on the same page. Spark SQL functions are a different language surface and are not enumerated by this DSL catalogue.High

Source: Purview data quality rules. These descriptions summarize published behavior, not scan results from the inspected tenant.

Reading the confidence column

High The stated purpose has clear source support. Medium The purpose is plausible, but metadata conflicts or important ambiguities remain. Low A material part of the description is inferred or unresolved. These are qualitative assessments, not calibrated probabilities.

Description confidence, client validation and runtime availability are independent. A clearly described or client-accepted function can still be unsupported. Expand a row to see the rationale, raw input/return-type metadata and exact probe results. Parameter metadata is an inventory, not a certified executable signature: overloads, variadic arguments, nulls, locale, timezone and source-specific behavior require validation.

Evidence boundary: The initially selected asset had no configured rules and its DQ asset metadata requests returned 404. The exact registry consumed by the expression builder was extracted read-only from the deployed client module. The follow-up checks invoked that module's actual client validator with an in-memory synthetic schema, avoiding asset setup. No rule, connection, identity, permission or scan was created or changed.

Functions missing from the main ADF reference

These nine names exist in the shipped registry but have no function section in the inspected alphabetical ADF reference. The General, Conversion, Map and Metafunction summary pages were also checked for named entries. This is a documentation-gap finding, not proof that the functions are undocumented everywhere.

Descriptions that should not be copied blindly

FunctionConflict and treatment
fromBase64Client text says encode. Public signature/examples establish decode; description corrected.
subDaysClient text says subtract months. Public signature/examples establish days; description corrected.
leastClient and public prose describe a comparison operator, but their examples return the minimum value. Medium confidence.
md5Binary, sha1Binary, sha2Binary, blake2bBinaryReturn types say binary, while some prose and examples are copied from non-binary siblings. Binary-output descriptions are qualified.
crc32Text contains SHA-like bit-length choices. The catalogue describes the checksum without asserting those choices as a valid CRC parameter.
toBitSetMinimum-argument count is two, but the declared inputs and example contain one argument.
sumDistinctIfThe name suggests conditional distinct summation, but the prose/examples do not establish duplicate treatment. Low confidence.
isUpsertThe name suggests upsert while the prose says insert. Low confidence, and explicitly unsupported in Purview.
mapAssociationThe public signature and example clarify that the result is an array, unlike reassociate, which returns a map.
jaroWinklerCalled a distance, but identical strings score 1.0 in the public example. Described as a similarity-style score.

How to use the examples

Every function has its own visible Example column below. Examples reuse the exact function expressions from the client checks, including the corrected mapLoop expression. They illustrate syntax, not observed runtime outputs. Replace the sample column names with your asset's columns.

ColumnTypeIllustrative value
ninteger3
xdouble12.5
ydouble4.0
sstring'alpha'
flagbooleantrue
ddate2026-09-16
tstimestamp2026-09-16 12:00:00

These values are explanatory only; the validator used column types, not actual rows. For aggregate examples, imagine several rows with these same column definitions. SyntheticInput is a hypothetical stream name, and synthetic_assertion is a hypothetical assertion ID; neither was created.

Building a row rule: a scalar expression such as abs(n) must be used in a Boolean condition, for example abs(n) <= 10. Array and map functions often need a surrounding condition too. The generic non-null wrappers retained under Client validation are parser probes, not recommended business rules. Unsupported functions and unknown-function diagnostics remain visibly marked next to their examples.

The complete inspected registry

Showing 259 of 259 functions

FunctionCategoriesDescription and caveatsExampleDescription confidenceClient validationRuntime support evidence (untested = not scan-tested)Sources
abs Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Returns the magnitude of a number without its sign.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: number

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

abs(n)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
abs(n)

Boolean row probe:
n >= 0 && !isNull(abs(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
acos Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the inverse cosine of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

acos(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
acos(0.5)

Boolean row probe:
n >= 0 && !isNull(acos(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
add Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Adds numbers, joins strings or compatible arrays, or adds days/durations to dates/timestamps.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

add(n, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
add(n, 2)

Boolean row probe:
n >= 0 && !isNull(add(n, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
addDays Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Moves a date or timestamp forward by a given number of days.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime, integral
Declared minimum parameters: 2
Declared return type: datetime

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

addDays(d, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
addDays(d, 2)

Boolean row probe:
n >= 0 && !isNull(addDays(d, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"date"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
addMonths Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Moves a date or timestamp forward by a given number of months; an optional timezone is accepted.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime, integral, string
Declared minimum parameters: 2
Declared return type: datetime

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

addMonths(d, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
addMonths(d, 2)

Boolean row probe:
n >= 0 && !isNull(addMonths(d, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"date"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
and Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Combines two Boolean expressions with logical AND.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, boolean
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

and(flag, n > 0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
and(flag, n > 0)

Boolean row probe:
n >= 0 && !isNull(and(flag, n > 0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, flag

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
approxDistinctCount Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Estimates the number of distinct values, optionally controlling estimation error.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, double
Declared minimum parameters: 1
Declared return type: long

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

approxDistinctCount(n)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
approxDistinctCount(n)

Boolean row probe:
n >= 0 && !isNull(approxDistinctCount(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
array Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Constructs an array from compatible items; an empty constructor defaults to a string array.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 0
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

array(n, 2, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
array(n, 2, 3)

Boolean row probe:
n >= 0 && !isNull(array(n, 2, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
asin Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the inverse sine of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

asin(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
asin(0.5)

Boolean row probe:
n >= 0 && !isNull(asin(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
associate Maps
Client type: Not specified
Rule family: Custom (ADF/DSL)
Builds a map from alternating key/value arguments with compatible key and value types.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 0
Declared return type: map

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

associate('alpha', 1, 'beta', 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
associate('alpha', 1, 'beta', 2)

Boolean row probe:
n >= 0 && !isNull(associate('alpha', 1, 'beta', 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"map","mapKeyType":{"typeString":"string"},"mapValueType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
at Arrays and collections
Client type: Not specified
Rule family: Custom (ADF/DSL)
Looks up a one-based array element or a map key; a missing position or key yields null.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: any

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

at([1, 2, 3], 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
at([1, 2, 3], 2)

Boolean row probe:
n >= 0 && !isNull(at([1, 2, 3], 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
atan Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the inverse tangent of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

atan(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
atan(0.5)

Boolean row probe:
n >= 0 && !isNull(atan(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
atan2 Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes a quadrant-aware angle in radians from two coordinate inputs.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number, number
Declared minimum parameters: 2
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

atan2(1.0, 2.0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
atan2(1.0, 2.0)

Boolean row probe:
n >= 0 && !isNull(atan2(1.0, 2.0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
avg Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the arithmetic average over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: number

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

avg(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
avg(x)

Boolean row probe:
n >= 0 && !isNull(avg(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
avgIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the arithmetic average using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: number

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

avgIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
avgIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(avgIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
between Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether a value falls within inclusive lower and upper bounds.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any, any
Declared minimum parameters: 3
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

between(n, 1, 10)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
between(n, 1, 10)

Boolean row probe:
n >= 0 && !isNull(between(n, 1, 10))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
bitwiseAnd Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Applies bitwise AND to integral values.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integral, integral
Declared minimum parameters: 2
Declared return type: integral

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

bitwiseAnd(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
bitwiseAnd(n, 3)

Boolean row probe:
n >= 0 && !isNull(bitwiseAnd(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
bitwiseOr Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Applies bitwise OR to integral values.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integral, integral
Declared minimum parameters: 2
Declared return type: integral

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

bitwiseOr(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
bitwiseOr(n, 3)

Boolean row probe:
n >= 0 && !isNull(bitwiseOr(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
bitwiseXor Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Applies bitwise exclusive OR to integral values.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

bitwiseXor(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
bitwiseXor(n, 3)

Boolean row probe:
n >= 0 && !isNull(bitwiseXor(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
blake2b Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Computes a BLAKE2b fingerprint with a requested digest bit length.
Evidence, signature metadata and caveats

Confidence rationale: Digest purpose is clear; declared minimum arguments is one despite examples taking bit length and input.

Declared input types: integer, any
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

blake2b(256, s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
blake2b(256, s)

Boolean row probe:
n >= 0 && !isNull(blake2b(256, s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
blake2bBinary Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Appears to return the BLAKE2b digest as binary; the shipped example invokes the non-binary sibling.
Evidence, signature metadata and caveats

Confidence rationale: Binary return type is present, but the example and minimum-argument metadata are inconsistent.

Declared input types: integer, any
Declared minimum parameters: 1
Declared return type: binary

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

blake2bBinary(256, s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
blake2bBinary(256, s)

Boolean row probe:
n >= 0 && !isNull(blake2bBinary(256, s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"binary"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
byItem Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Selects a named member from a structure or array of structures; a missing match yields null.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string
Declared minimum parameters: 2
Declared return type: string

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

toString(byItem(@(child = s), 'child'))

Diagnostic illustration only: the inspected client reports this function as unknown. Not a working Purview example.

Example column definitions
High Diagnostic returned
Exact expression and result

Function probe:
toString(byItem(@(child = s), 'child'))

Boolean row probe:
n >= 0 && !isNull(toString(byItem(@(child = s), 'child')))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Row diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
byName Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Selects a column by name, optionally from a named stream; the result may need explicit conversion.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

toString(byName('s'))

Diagnostic illustration only: the inspected client reports this function as unknown. Not a working Purview example.

Example column definitions
High Diagnostic returned
Exact expression and result

Function probe:
toString(byName('s'))

Boolean row probe:
n >= 0 && !isNull(toString(byName('s')))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Row diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
byNames Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Selects multiple columns by name, optionally within a named stream.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, string
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

md5(byNames(['n', 's']))

Diagnostic illustration only: the inspected client reports this function as unknown. Not a working Purview example.

Example column definitions
High Diagnostic returned
Exact expression and result

Function probe:
md5(byNames(['n', 's']))

Boolean row probe:
n >= 0 && !isNull(md5(byNames(['n', 's'])))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Row diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
byOrigin Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Selects a named column from the stream in which it originated.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

toString(byOrigin('s', 'SyntheticInput'))

Diagnostic illustration only: the inspected client reports this function as unknown. Not a working Purview example.

Example column definitions
High Diagnostic returned
Exact expression and result

Function probe:
toString(byOrigin('s', 'SyntheticInput'))

Boolean row probe:
n >= 0 && !isNull(toString(byOrigin('s', 'SyntheticInput')))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Row diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
byOrigins Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Selects multiple columns using their names and originating stream.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, string
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

md5(byOrigins(['n', 's'], 'SyntheticInput'))

Diagnostic illustration only: the inspected client reports this function as unknown. Not a working Purview example.

Example column definitions
High Diagnostic returned
Exact expression and result

Function probe:
md5(byOrigins(['n', 's'], 'SyntheticInput'))

Boolean row probe:
n >= 0 && !isNull(md5(byOrigins(['n', 's'], 'SyntheticInput')))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Row diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
byPath Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Selects a value using a hierarchical path; a missing path yields null.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

toString(byPath('s'))

Diagnostic illustration only: the inspected client reports this function as unknown. Not a working Purview example.

Example column definitions
High Diagnostic returned
Exact expression and result

Function probe:
toString(byPath('s'))

Boolean row probe:
n >= 0 && !isNull(toString(byPath('s')))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Row diagnostics: languages.dsl.validation.DSLEditorErrorUnknownFunction

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
byPosition Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Selects a column by one-based position; out-of-range positions yield null.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

toInteger(byPosition(1))

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toInteger(byPosition(1))

Boolean row probe:
n >= 0 && !isNull(toInteger(byPosition(1)))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
case Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Chooses a result from condition/result pairs, with an optional final fallback.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, any, any
Declared minimum parameters: 3
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

case(flag, 'yes', 'no')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
case(flag, 'yes', 'no')

Boolean row probe:
n >= 0 && !isNull(case(flag, 'yes', 'no'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, flag

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
cbrt Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes a number's cube root.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

cbrt(27)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
cbrt(27)

Boolean row probe:
n >= 0 && !isNull(cbrt(27))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
ceil Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Rounds upward to the nearest integer.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: number

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

ceil(x)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
ceil(x)

Boolean row probe:
n >= 0 && !isNull(ceil(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
coalesce Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Chooses the first non-null input from compatible values.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

coalesce(s, 'fallback')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
coalesce(s, 'fallback')

Boolean row probe:
n >= 0 && !isNull(coalesce(s, 'fallback'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
collect Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Accumulates group values into an array; keep resulting groups small to avoid excessive memory use.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: array

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

collect(s)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
collect(s)

Boolean row probe:
n >= 0 && !isNull(collect(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"string"}}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
columnNames Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Returns the output column names of a stream.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 0
Declared return type: string[]

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

columnNames()

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
columnNames()

Boolean row probe:
n >= 0 && !isNull(columnNames())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"string"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
columns Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Returns the output column values of a stream.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 0
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

md5(columns())

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
md5(columns())

Boolean row probe:
n >= 0 && !isNull(md5(columns()))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
compare Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Orders two same-type values: negative for less, zero for equal, positive for greater.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

compare(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
compare(n, 3)

Boolean row probe:
n >= 0 && !isNull(compare(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
concat Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Joins the supplied strings in order.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

concat(s, '-test')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
concat(s, '-test')

Boolean row probe:
n >= 0 && !isNull(concat(s, '-test'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
concatWS Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Joins strings using the first argument as a separator.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string, string
Declared minimum parameters: 3
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

concatWS('-', s, 'test')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
concatWS('-', s, 'test')

Boolean row probe:
n >= 0 && !isNull(concatWS('-', s, 'test'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
contains Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether any array item satisfies a predicate expressed with #item.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, unaryfunction
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

contains([1, 2, 3], #item > 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
contains([1, 2, 3], #item > 1)

Boolean row probe:
n >= 0 && !isNull(contains([1, 2, 3], #item > 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
cos Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the cosine of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

cos(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
cos(0.5)

Boolean row probe:
n >= 0 && !isNull(cos(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
cosh Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the hyperbolic cosine of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

cosh(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
cosh(0.5)

Boolean row probe:
n >= 0 && !isNull(cosh(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
count Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Counts rows or non-null values when column arguments are supplied.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 0
Declared return type: long

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

count(n)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
count(n)

Boolean row probe:
n >= 0 && !isNull(count(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
countDistinct Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Counts distinct combinations of supplied column values.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 1
Declared return type: long

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

countDistinct(n, s)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
countDistinct(n, s)

Boolean row probe:
n >= 0 && !isNull(countDistinct(n, s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
countIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Counts qualifying rows, or qualifying non-null values when a column is supplied.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, any
Declared minimum parameters: 1
Declared return type: long

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

countIf(flag, n)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
countIf(flag, n)

Boolean row probe:
n >= 0 && !isNull(countIf(flag, n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n, flag

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
covariancePopulation Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the population covariance of two columns over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

covariancePopulation(x, y)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
covariancePopulation(x, y)

Boolean row probe:
n >= 0 && !isNull(covariancePopulation(x, y))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x, y

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
covariancePopulationIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the population covariance of two columns using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number, number
Declared minimum parameters: 3
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

covariancePopulationIf(flag, x, y)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
covariancePopulationIf(flag, x, y)

Boolean row probe:
n >= 0 && !isNull(covariancePopulationIf(flag, x, y))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x, y

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
covarianceSample Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the sample covariance of two columns over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

covarianceSample(x, y)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
covarianceSample(x, y)

Boolean row probe:
n >= 0 && !isNull(covarianceSample(x, y))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x, y

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
covarianceSampleIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the sample covariance of two columns using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number, number
Declared minimum parameters: 3
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

covarianceSampleIf(flag, x, y)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
covarianceSampleIf(flag, x, y)

Boolean row probe:
n >= 0 && !isNull(covarianceSampleIf(flag, x, y))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x, y

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
crc32 Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Computes a CRC-32 checksum over input values. Do not interpret the conflicting SHA-like bit-length prose as a confirmed parameter.
Evidence, signature metadata and caveats

Confidence rationale: CRC-32 purpose is clear, but both sources contain suspect SHA-style bit-length text. Signature details are not asserted.

Declared input types: any
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

crc32(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
crc32(s)

Boolean row probe:
n >= 0 && !isNull(crc32(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
cumeDist Window functions
Client type: Window
Rule family: Custom (ADF/DSL)
Calculates a row's cumulative distribution within an ordered window partition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: integer

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

cumeDist()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
cumeDist()

Boolean row probe:
n >= 0 && !isNull(cumeDist())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
currentDate Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Returns the job-start date, optionally interpreted in a specified timezone.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 0
Declared return type: date

Result can depend on execution time, partition or generated values; consider rule reproducibility.

currentDate()

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
currentDate()

Boolean row probe:
n >= 0 && !isNull(currentDate())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"date"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
currentTimestamp Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Returns the job-start timestamp in the execution environment's local timezone.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: timestamp

Result can depend on execution time, partition or generated values; consider rule reproducibility.

currentTimestamp()

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
currentTimestamp()

Boolean row probe:
n >= 0 && !isNull(currentTimestamp())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"timestamp"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
currentUTC Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Returns a current UTC timestamp; the optional timezone affects interpretation of the source time.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 0
Declared return type: timestamp

Result can depend on execution time, partition or generated values; consider rule reproducibility.

currentUTC()

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
currentUTC()

Boolean row probe:
n >= 0 && !isNull(currentUTC())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"timestamp"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
dayOfMonth Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Extracts the day-of-month component from a compatible date/time value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

dayOfMonth(d)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
dayOfMonth(d)

Boolean row probe:
n >= 0 && !isNull(dayOfMonth(d))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
dayOfWeek Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Returns a weekday number: Sunday is 1 and Saturday is 7.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

dayOfWeek(d)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
dayOfWeek(d)

Boolean row probe:
n >= 0 && !isNull(dayOfWeek(d))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
dayOfYear Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Extracts the day-of-year component from a compatible date/time value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

dayOfYear(d)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
dayOfYear(d)

Boolean row probe:
n >= 0 && !isNull(dayOfYear(d))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
days Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Converts a quantity of days into a duration measured in milliseconds.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

days(2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
days(2)

Boolean row probe:
n >= 0 && !isNull(days(2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
degrees Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Changes an angle from radians to degrees.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

degrees(1.0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
degrees(1.0)

Boolean row probe:
n >= 0 && !isNull(degrees(1.0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
denseRank Window functions
Client type: Window
Rule family: Custom (ADF/DSL)
Assigns ranks to ordered values without leaving gaps after ties.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: integer

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

denseRank()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
denseRank()

Boolean row probe:
n >= 0 && !isNull(denseRank())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
distinct Arrays and collections
Client type: Not specified
Rule family: Custom (ADF/DSL)
Removes duplicate items from an array.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array
Declared minimum parameters: 1
Declared return type: array

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

distinct([1, 2, 1])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
distinct([1, 2, 1])

Boolean row probe:
n >= 0 && !isNull(distinct([1, 2, 1]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
divide Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Divides one numeric value by another.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

divide(x, 2.0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
divide(x, 2.0)

Boolean row probe:
n >= 0 && !isNull(divide(x, 2.0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
dropLeft Strings and pattern matching
Client type: Not specified
Rule family: Custom (ADF/DSL)
Removes a specified number of leading characters; over-removal produces an empty string.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, integral
Declared minimum parameters: 2
Declared return type: string

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

dropLeft(s, 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
dropLeft(s, 1)

Boolean row probe:
n >= 0 && !isNull(dropLeft(s, 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
dropRight Strings and pattern matching
Client type: Not specified
Rule family: Custom (ADF/DSL)
Removes a specified number of trailing characters; over-removal produces an empty string.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, integral
Declared minimum parameters: 2
Declared return type: string

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

dropRight(s, 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
dropRight(s, 1)

Boolean row probe:
n >= 0 && !isNull(dropRight(s, 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
endsWith Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether text ends with a specified suffix.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

endsWith(s, 'z')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
endsWith(s, 'z')

Boolean row probe:
n >= 0 && !isNull(endsWith(s, 'z'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
equals Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Tests equality of two values.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

equals(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
equals(n, 3)

Boolean row probe:
n >= 0 && !isNull(equals(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
equalsIgnoreCase Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Compares values for equality without distinguishing letter case.
Evidence, signature metadata and caveats

Confidence rationale: Case-insensitive comparison is documented, but operator spellings differ across shipped metadata; use the function name.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

equalsIgnoreCase(s, 'ALPHA')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
equalsIgnoreCase(s, 'ALPHA')

Boolean row probe:
n >= 0 && !isNull(equalsIgnoreCase(s, 'ALPHA'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
escape Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Escapes text for a named format such as JSON, XML, HTML, Java or ECMAScript.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

escape(s, 'json')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
escape(s, 'json')

Boolean row probe:
n >= 0 && !isNull(escape(s, 'json'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
except Arrays and collections
Client type: Not specified
Rule family: Custom (ADF/DSL)
Returns distinct items present in the first array but absent from the second.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, array
Declared minimum parameters: 2
Declared return type: array

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

except([1, 2, 3], [2])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
except([1, 2, 3], [2])

Boolean row probe:
n >= 0 && !isNull(except([1, 2, 3], [2]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
expr Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Interprets a string as an expression rather than a literal value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

expr('n + 1')

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
expr('n + 1')

Boolean row probe:
n >= 0 && !isNull(expr('n + 1'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
factorial Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the factorial of the supplied number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

factorial(4)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
factorial(4)

Boolean row probe:
n >= 0 && !isNull(factorial(4))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
false Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Produces the Boolean constant false.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

false()

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
false()

Boolean row probe:
n >= 0 && !isNull(false())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
filter Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Retains array elements that satisfy a predicate using #item.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, unaryfunction
Declared minimum parameters: 2
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

filter([1, 2, 3], #item > 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
filter([1, 2, 3], #item > 1)

Boolean row probe:
n >= 0 && !isNull(filter([1, 2, 3], #item > 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
find Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Returns the first array item satisfying the supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, unaryfunction
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

find([1, 2, 3], #item > 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
find([1, 2, 3], #item > 1)

Boolean row probe:
n >= 0 && !isNull(find([1, 2, 3], #item > 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
first Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Returns a group's first value, with an optional ignore-nulls setting; meaningful order is required.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, boolean
Declared minimum parameters: 1
Declared return type: any

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract. No stable order was established for Purview scans; do not infer deterministic first/last selection.

first(n)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
first(n)

Boolean row probe:
n >= 0 && !isNull(first(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
flatten Arrays and collections
Client type: Not specified
Rule family: Custom (ADF/DSL)
Combines nested arrays into one array, with an optional recursive-flattening mode.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, boolean
Declared minimum parameters: 1
Declared return type: array

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

flatten([[1, 2], [3]])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
flatten([[1, 2], [3]])

Boolean row probe:
n >= 0 && !isNull(flatten([[1, 2], [3]]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
floor Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Rounds downward to the nearest integer.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: number

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

floor(x)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
floor(x)

Boolean row probe:
n >= 0 && !isNull(floor(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
fromBase64 Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Decodes Base64 text; the shipped description incorrectly says it encodes.
Evidence, signature metadata and caveats

Confidence rationale: Corrected using the public decoding example; the client description says encoding.

Declared input types: string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

fromBase64('YWJj')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
fromBase64('YWJj')

Boolean row probe:
n >= 0 && !isNull(fromBase64('YWJj'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
fromUTC Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Converts a UTC timestamp into a specified timezone or the execution environment's default.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: timestamp, string
Declared minimum parameters: 1
Declared return type: timestamp

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

fromUTC(ts, 'Europe/Berlin')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
fromUTC(ts, 'Europe/Berlin')

Boolean row probe:
n >= 0 && !isNull(fromUTC(ts, 'Europe/Berlin'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"timestamp"}
Inferred row type: boolean
Row column references: n, ts

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
greater Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether the first value exceeds the second.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

greater(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
greater(n, 3)

Boolean row probe:
n >= 0 && !isNull(greater(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
greaterOrEqual Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether the first value is at least the second.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

greaterOrEqual(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
greaterOrEqual(n, 3)

Boolean row probe:
n >= 0 && !isNull(greaterOrEqual(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
greatest Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Selects the largest of the supplied values, ignoring nulls unless all are null.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

greatest(n, 3, 5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
greatest(n, 3, 5)

Boolean row probe:
n >= 0 && !isNull(greatest(n, 3, 5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
hasColumn Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether a named column exists in the stream schema.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

hasColumn('n')

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
hasColumn('n')

Boolean row probe:
n >= 0 && !isNull(hasColumn('n'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
hasError Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether a named assertion is marked as failed; requires an assertion context.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: boolean

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

hasError('synthetic_assertion')

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
hasError('synthetic_assertion')

Boolean row probe:
n >= 0 && !isNull(hasError('synthetic_assertion'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
hasPath Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether a named hierarchical path exists in a stream.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

hasPath('s')

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
hasPath('s')

Boolean row probe:
n >= 0 && !isNull(hasPath('s'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
hex Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Encodes binary data as hexadecimal text.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: binary
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

hex(toBinary(s))

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
hex(toBinary(s))

Boolean row probe:
n >= 0 && !isNull(hex(toBinary(s)))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
hour Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Extracts the hour component from a compatible date/time value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: timestamp, string
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

hour(ts)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
hour(ts)

Boolean row probe:
n >= 0 && !isNull(hour(ts))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, ts

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
hours Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Converts a quantity of hours into a duration measured in milliseconds.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

hours(2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
hours(2)

Boolean row probe:
n >= 0 && !isNull(hours(2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
iif Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Selects a true-branch or false-branch value; an omitted false branch yields null.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, any, any
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

iif(flag, n, 0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
iif(flag, n, 0)

Boolean row probe:
n >= 0 && !isNull(iif(flag, n, 0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, flag

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
iifNull Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Returns the first available non-null input.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any, any
Declared minimum parameters: 1
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

iifNull(s, 'fallback')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
iifNull(s, 'fallback')

Boolean row probe:
n >= 0 && !isNull(iifNull(s, 'fallback'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
in Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether a supplied value occurs in an array.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, any
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

in([1, 2, 3], n)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
in([1, 2, 3], n)

Boolean row probe:
n >= 0 && !isNull(in([1, 2, 3], n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
initCap Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Capitalizes the first letter of each whitespace-separated word.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

initCap(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
initCap(s)

Boolean row probe:
n >= 0 && !isNull(initCap(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
instr Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Finds a substring's one-based position; zero indicates no match.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

instr(s, 'a')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
instr(s, 'a')

Boolean row probe:
n >= 0 && !isNull(instr(s, 'a'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
intersect Arrays and collections
Client type: Not specified
Rule family: Custom (ADF/DSL)
Returns the distinct items shared by two arrays.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, array
Declared minimum parameters: 2
Declared return type: array

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

intersect([1, 2], [2, 3])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
intersect([1, 2], [2, 3])

Boolean row probe:
n >= 0 && !isNull(intersect([1, 2], [2, 3]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isAssignable Metadata and expression helpers
Client type: Not specified
Rule family: Custom (ADF/DSL)
Tests compatibility between a column/expression and a datatype description; the exact direction of assignment needs validation.
Evidence, signature metadata and caveats

Confidence rationale: Client-only evidence; text and examples do not establish assignment direction precisely.

Declared input types: any, string
Declared minimum parameters: 2
Declared return type: boolean

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule. The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

isAssignable(n, 'decimal')

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
Low Accepted (client)
Exact expression and result

Function probe:
isAssignable(n, 'decimal')

Boolean row probe:
n >= 0 && !isNull(isAssignable(n, 'decimal'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
No main ADF entry
isBitSet Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether a given bit position is enabled in a bitset.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, integer
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isBitSet(toBitSet([1, 3]), 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isBitSet(toBitSet([1, 3]), 1)

Boolean row probe:
n >= 0 && !isNull(isBitSet(toBitSet([1, 3]), 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isBoolean Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toBoolean, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isBoolean('true')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isBoolean('true')

Boolean row probe:
n >= 0 && !isNull(isBoolean('true'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isByte Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toByte, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isByte('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isByte('12')

Boolean row probe:
n >= 0 && !isNull(isByte('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isDate Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toDate, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isDate('2026-09-16')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isDate('2026-09-16')

Boolean row probe:
n >= 0 && !isNull(isDate('2026-09-16'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isDecimal Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toDecimal, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isDecimal('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isDecimal('12')

Boolean row probe:
n >= 0 && !isNull(isDecimal('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isDelete Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests an ADF row's delete marker.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 0
Declared return type: boolean

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

isDelete()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isDelete()

Boolean row probe:
n >= 0 && !isNull(isDelete())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
isDistinct Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Evaluates distinctness of one or more columns within an aggregate context, excluding null as a distinct value.
Evidence, signature metadata and caveats

Confidence rationale: Aggregate distinctness is described, but exact group-versus-row scoring behavior in Purview was not established.

Declared input types: any, any
Declared minimum parameters: 1
Declared return type: boolean

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

isDistinct(n, s)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
isDistinct(n, s)

Boolean row probe:
n >= 0 && !isNull(isDistinct(n, s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isDouble Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toDouble, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isDouble('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isDouble('12')

Boolean row probe:
n >= 0 && !isNull(isDouble('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isError Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests an ADF row's error marker.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 0
Declared return type: boolean

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

isError()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isError()

Boolean row probe:
n >= 0 && !isNull(isError())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
isFloat Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toFloat, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isFloat('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isFloat('12')

Boolean row probe:
n >= 0 && !isNull(isFloat('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isIgnore Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests an ADF row's ignore marker.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 0
Declared return type: boolean

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

isIgnore()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isIgnore()

Boolean row probe:
n >= 0 && !isNull(isIgnore())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
isInsert Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests an ADF row's insert marker.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 0
Declared return type: boolean

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

isInsert()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isInsert()

Boolean row probe:
n >= 0 && !isNull(isInsert())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
isInteger Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toInteger, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isInteger('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isInteger('12')

Boolean row probe:
n >= 0 && !isNull(isInteger('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isLong Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toLong, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isLong('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isLong('12')

Boolean row probe:
n >= 0 && !isNull(isLong('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isMatch Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether an ADF lookup matched a row.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 0
Declared return type: boolean

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

isMatch()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isMatch()

Boolean row probe:
n >= 0 && !isNull(isMatch())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
isNan Numeric and mathematical
Client type: Not specified
Rule family: Custom (ADF/DSL)
Tests for the special numeric NaN value, rather than missing/null data.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: boolean

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

isNan(x)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isNan(x)

Boolean row probe:
n >= 0 && !isNull(isNan(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isNull Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Tests for null; this is not by itself a whitespace or empty-string check.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isNull(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isNull(s)

Boolean row probe:
n >= 0 && !isNull(isNull(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isShort Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toShort, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isShort('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isShort('12')

Boolean row probe:
n >= 0 && !isNull(isShort('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isTimestamp Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Checks whether an input string is valid for conversion by toTimestamp, using the supported optional format settings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

isTimestamp('2026-09-16 12:00:00')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isTimestamp('2026-09-16 12:00:00')

Boolean row probe:
n >= 0 && !isNull(isTimestamp('2026-09-16 12:00:00'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
isUpdate Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Tests an ADF row's update marker.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 0
Declared return type: boolean

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

isUpdate()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
isUpdate()

Boolean row probe:
n >= 0 && !isNull(isUpdate())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
isUpsert Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Intended to test an ADF upsert marker; the source text instead repeats insert-marker wording.
Evidence, signature metadata and caveats

Confidence rationale: The name implies upsert, but both descriptions say insert; also explicitly unsupported in Purview.

Declared input types: integer
Declared minimum parameters: 0
Declared return type: boolean

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

isUpsert()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
Low Accepted (client)
Exact expression and result

Function probe:
isUpsert()

Boolean row probe:
n >= 0 && !isNull(isUpsert())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
jaroWinkler Strings and pattern matching
Client type: Not specified
Rule family: Custom (ADF/DSL)
Computes a Jaro-Winkler string-match score. The documented identical-string example returns 1.0.
Evidence, signature metadata and caveats

Confidence rationale: Sources call this distance, but the identical-string example returns 1.0, indicating a similarity-style score.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: double

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

jaroWinkler(s, 'alpha')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
jaroWinkler(s, 'alpha')

Boolean row probe:
n >= 0 && !isNull(jaroWinkler(s, 'alpha'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
keys Maps
Client type: General
Rule family: Custom (ADF/DSL)
Returns the keys of a map.
Evidence, signature metadata and caveats

Confidence rationale: Client description and array-returning map examples agree; no main ADF entry found.

Declared input types: map
Declared minimum parameters: 1
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

keys(['alpha' -> 1, 'beta' -> 2])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
keys(['alpha' -> 1, 'beta' -> 2])

Boolean row probe:
n >= 0 && !isNull(keys(['alpha' -> 1, 'beta' -> 2]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
No main ADF entry
keyValues Maps
Client type: Not specified
Rule family: Custom (ADF/DSL)
Builds a map from equally sized arrays of keys and values.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, array
Declared minimum parameters: 2
Declared return type: map

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

keyValues(['alpha', 'beta'], [1, 2])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
keyValues(['alpha', 'beta'], [1, 2])

Boolean row probe:
n >= 0 && !isNull(keyValues(['alpha', 'beta'], [1, 2]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"map","mapKeyType":{"typeString":"string"},"mapValueType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
kurtosis Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the kurtosis over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

kurtosis(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
kurtosis(x)

Boolean row probe:
n >= 0 && !isNull(kurtosis(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
kurtosisIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the kurtosis using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

kurtosisIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
kurtosisIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(kurtosisIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
lag Window functions
Client type: Window
Rule family: Custom (ADF/DSL)
Reads a value from an earlier row in the window, with optional offset and fallback.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, number, any
Declared minimum parameters: 1
Declared return type: any

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

lag(n, 1, 0)

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
lag(n, 1, 0)

Boolean row probe:
n >= 0 && !isNull(lag(n, 1, 0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
last Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Returns a group's last value, with an optional ignore-nulls setting; meaningful order is required.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, boolean
Declared minimum parameters: 1
Declared return type: any

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract. No stable order was established for Purview scans; do not infer deterministic first/last selection.

last(n)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
last(n)

Boolean row probe:
n >= 0 && !isNull(last(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
lastDayOfMonth Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Returns the date of the final day in the input's month.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime
Declared minimum parameters: 1
Declared return type: date

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

lastDayOfMonth(d)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
lastDayOfMonth(d)

Boolean row probe:
n >= 0 && !isNull(lastDayOfMonth(d))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"date"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
lead Window functions
Client type: Window
Rule family: Custom (ADF/DSL)
Reads a value from a later row in the window, with optional offset and fallback.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, number, any
Declared minimum parameters: 1
Declared return type: any

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

lead(n, 1, 0)

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
lead(n, 1, 0)

Boolean row probe:
n >= 0 && !isNull(lead(n, 1, 0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
least Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Selects the smallest supplied value; it is not a Boolean less-than-or-equal comparison.
Evidence, signature metadata and caveats

Confidence rationale: Client and public prose incorrectly describe <=; both examples instead return the minimum value.

Declared input types: any
Declared minimum parameters: 1
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

least(n, 3, 5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
least(n, 3, 5)

Boolean row probe:
n >= 0 && !isNull(least(n, 3, 5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
left Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Returns a requested number of characters from the beginning of text.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, integral
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

left(s, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
left(s, 2)

Boolean row probe:
n >= 0 && !isNull(left(s, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
length Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Reports a string's length.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

length(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
length(s)

Boolean row probe:
n >= 0 && !isNull(length(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
lesser Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether the first value is below the second.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

lesser(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
lesser(n, 3)

Boolean row probe:
n >= 0 && !isNull(lesser(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
lesserOrEqual Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether the first value is at most the second.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

lesserOrEqual(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
lesserOrEqual(n, 3)

Boolean row probe:
n >= 0 && !isNull(lesserOrEqual(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
levenshtein Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Computes the edit distance between two strings.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

levenshtein(s, 'alpha')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
levenshtein(s, 'alpha')

Boolean row probe:
n >= 0 && !isNull(levenshtein(s, 'alpha'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
like Strings and pattern matching
Client type: General
Rule family: Custom; String format match
Matches a text pattern with percent for any-length text and underscore for one character.
Evidence, signature metadata and caveats

Confidence rationale: Wildcard semantics are documented, but escape-character wording differs between sources; no escape character is prescribed here.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

like(s, 'a%')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
like(s, 'a%')

Boolean row probe:
n >= 0 && !isNull(like(s, 'a%'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
locate Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Finds a substring's one-based position, optionally starting at a given position; zero means no match.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string, integral
Declared minimum parameters: 2
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

locate('a', s, 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
locate('a', s, 1)

Boolean row probe:
n >= 0 && !isNull(locate('a', s, 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
log Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes a logarithm, using the natural base unless another base is supplied.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number, number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

log(100.0, 10.0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
log(100.0, 10.0)

Boolean row probe:
n >= 0 && !isNull(log(100.0, 10.0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
log10 Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes a base-10 logarithm.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

log10(100.0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
log10(100.0)

Boolean row probe:
n >= 0 && !isNull(log10(100.0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
lower Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Changes text to lowercase.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

lower(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
lower(s)

Boolean row probe:
n >= 0 && !isNull(lower(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
lpad Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Pads the left side to a target length, or truncates text already longer than that target.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, integral, string
Declared minimum parameters: 3
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

lpad(s, 10, '0')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
lpad(s, 10, '0')

Boolean row probe:
n >= 0 && !isNull(lpad(s, 10, '0'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
ltrim Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Removes leading whitespace, or leading characters from a supplied set.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

ltrim(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
ltrim(s)

Boolean row probe:
n >= 0 && !isNull(ltrim(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
map Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Transforms each array item using an expression referencing #item.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, unaryfunction
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

map([1, 2, 3], #item + 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
map([1, 2, 3], #item + 1)

Boolean row probe:
n >= 0 && !isNull(map([1, 2, 3], #item + 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
mapAssociation Maps
Client type: Not specified
Rule family: Custom (ADF/DSL)
Transforms map entries into an array using expressions over #key and #value.
Evidence, signature metadata and caveats

Confidence rationale: Public signature and example resolve the client description: this returns an array, not a map.

Declared input types: map, binaryfunction
Declared minimum parameters: 2
Declared return type: array

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

mapAssociation(['alpha' -> 1, 'beta' -> 2], @(key = #key, value = #value))

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
mapAssociation(['alpha' -> 1, 'beta' -> 2], @(key = #key, value = #value))

Boolean row probe:
n >= 0 && !isNull(mapAssociation(['alpha' -> 1, 'beta' -> 2], @(key = #key, value = #value)))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"complex","fields":[]}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
mapIf Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Conditionally transforms array items; the result may contain fewer elements.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, binaryfunction, binaryfunction
Declared minimum parameters: 3
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

mapIf([1, 2, 3], #item > 1, #item + 10)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
mapIf([1, 2, 3], #item > 1, #item + 10)

Boolean row probe:
n >= 0 && !isNull(mapIf([1, 2, 3], #item > 1, #item + 10))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
mapIndex Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Transforms array items while exposing both #item and #index.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, binaryfunction
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

mapIndex([1, 2, 3], #item + #index)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
mapIndex([1, 2, 3], #item + #index)

Boolean row probe:
n >= 0 && !isNull(mapIndex([1, 2, 3], #item + #index))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
mapLoop Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Builds an array by evaluating an expression for indexes from one through a specified length.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer, unaryfunction
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

mapLoop(3, toInteger(#index) * 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions

The integer conversion avoids the client type diagnostic on arithmetic with #index.

High Accepted (client)
Exact expression and result

Function probe:
mapLoop(3, toInteger(#index) * 2)

Boolean row probe:
n >= 0 && !isNull(mapLoop(3, toInteger(#index) * 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Earlier attempt retained: mapLoop(3, #index * 2)
languages.dsl.validation.DSL_ShouldReturnSameType {"type":"any"}
Refined with an explicit integer conversion of #index.

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
max Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the maximum over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: any

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

max(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
max(x)

Boolean row probe:
n >= 0 && !isNull(max(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
maxIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the maximum using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, any
Declared minimum parameters: 2
Declared return type: any

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

maxIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
maxIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(maxIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
md5 Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Computes an MD5 fingerprint represented as hexadecimal text; not appropriate for cryptographic security.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

md5(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
md5(s)

Boolean row probe:
n >= 0 && !isNull(md5(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
md5Binary Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Appears to return an MD5 digest as binary rather than hexadecimal text, based on the declared return type.
Evidence, signature metadata and caveats

Confidence rationale: Binary return type contradicts copied hex-string prose; example invokes md5 rather than md5Binary.

Declared input types: any
Declared minimum parameters: 1
Declared return type: binary

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

md5Binary(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
md5Binary(s)

Boolean row probe:
n >= 0 && !isNull(md5Binary(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"binary"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
No main ADF entry
mean Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the arithmetic average (alias of avg) over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: number

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

mean(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
mean(x)

Boolean row probe:
n >= 0 && !isNull(mean(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
meanIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the arithmetic average (alias of avg) using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: number

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

meanIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
meanIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(meanIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
millisecond Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Extracts the millisecond component from a compatible date/time value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: timestamp, string
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

millisecond(ts)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
millisecond(ts)

Boolean row probe:
n >= 0 && !isNull(millisecond(ts))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, ts

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
milliseconds Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Converts a quantity of milliseconds into a duration measured in milliseconds.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

milliseconds(2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
milliseconds(2)

Boolean row probe:
n >= 0 && !isNull(milliseconds(2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
min Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the minimum over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: any

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

min(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
min(x)

Boolean row probe:
n >= 0 && !isNull(min(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
minIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the minimum using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, any
Declared minimum parameters: 2
Declared return type: any

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

minIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
minIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(minIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
minus Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Subtracts numbers, days from dates, or durations from timestamps; timestamp differences are in milliseconds.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

minus(n, 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
minus(n, 1)

Boolean row probe:
n >= 0 && !isNull(minus(n, 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
minute Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Extracts the minute component from a compatible date/time value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: timestamp, string
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

minute(ts)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
minute(ts)

Boolean row probe:
n >= 0 && !isNull(minute(ts))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, ts

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
minutes Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Converts a quantity of minutes into a duration measured in milliseconds.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

minutes(2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
minutes(2)

Boolean row probe:
n >= 0 && !isNull(minutes(2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
mod Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Returns the remainder of numeric division.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

mod(n, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
mod(n, 2)

Boolean row probe:
n >= 0 && !isNull(mod(n, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
month Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Extracts the month component from a compatible date/time value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

month(d)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
month(d)

Boolean row probe:
n >= 0 && !isNull(month(d))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
monthsBetween Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Computes the month difference between dates, with optional rounding and timezone controls.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime, datetime, boolean, string
Declared minimum parameters: 2
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

monthsBetween(d, toDate('2026-01-01'))

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
monthsBetween(d, toDate('2026-01-01'))

Boolean row probe:
n >= 0 && !isNull(monthsBetween(d, toDate('2026-01-01')))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
multiply Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Multiplies numeric inputs.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

multiply(n, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
multiply(n, 2)

Boolean row probe:
n >= 0 && !isNull(multiply(n, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
negate Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Changes a number to its additive inverse.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: number

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

negate(n)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
negate(n)

Boolean row probe:
n >= 0 && !isNull(negate(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
nextSequence Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Generates a partition-prefixed sequence; it is only consecutive within a partition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: long

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule. Result can depend on execution time, partition or generated values; consider rule reproducibility.

nextSequence()

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
nextSequence()

Boolean row probe:
n >= 0 && !isNull(nextSequence())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
normalize Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Decomposes accented Unicode characters; the exact normalization form is not established here.
Evidence, signature metadata and caveats

Confidence rationale: Unicode decomposition is described; exact normalization form and edge behavior are unspecified.

Declared input types: string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

normalize(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
normalize(s)

Boolean row probe:
n >= 0 && !isNull(normalize(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
not Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Reverses a Boolean condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

not(flag)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
not(flag)

Boolean row probe:
n >= 0 && !isNull(not(flag))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, flag

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
notEquals Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether two values differ.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

notEquals(n, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
notEquals(n, 3)

Boolean row probe:
n >= 0 && !isNull(notEquals(n, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
notNull Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Tests that a value is non-null. The shipped example treats an empty string as non-null.
Evidence, signature metadata and caveats

Confidence rationale: Client description, Boolean return type and explicit null/empty-string examples agree; no main ADF entry found.

Declared input types: any
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

notNull(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
notNull(s)

Boolean row probe:
n >= 0 && !isNull(notNull(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
No main ADF entry
nTile Window functions
Client type: Window
Rule family: Custom (ADF/DSL)
Divides a window partition into a requested number of near-equal buckets.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 0
Declared return type: integer

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

nTile(4)

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
nTile(4)

Boolean row probe:
n >= 0 && !isNull(nTile(4))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
null Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Produces a null value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: null

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

null()

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions

Use inside a surrounding expression such as isNull(null()); a standalone null value receives a client diagnostic.

High Accepted (client)
Exact expression and result

Function probe:
null()

Boolean row probe:
n >= 0 && !isNull(null())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: languages.dsl.validation.DSLEditorErrorNullValue

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"null"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
or Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Combines two Boolean expressions with logical OR.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, boolean
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

or(flag, n > 0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
or(flag, n > 0)

Boolean row probe:
n >= 0 && !isNull(or(flag, n > 0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, flag

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
originColumns Metadata and expression helpers
Client type: Not specified
Rule family: Custom (ADF/DSL)
Returns columns associated with the stream where they were originally created.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule. The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

md5(originColumns('SyntheticInput'))

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
md5(originColumns('SyntheticInput'))

Boolean row probe:
n >= 0 && !isNull(md5(originColumns('SyntheticInput')))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
partitionId Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Returns the execution partition identifier for a row.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: integer

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

partitionId()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
partitionId()

Boolean row probe:
n >= 0 && !isNull(partitionId())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
pMod Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the positive-modulus variant of remainder.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, any
Declared minimum parameters: 2
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

pMod(n, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
pMod(n, 2)

Boolean row probe:
n >= 0 && !isNull(pMod(n, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
power Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Raises a numeric base to an exponent.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number, number
Declared minimum parameters: 2
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

power(n, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
power(n, 2)

Boolean row probe:
n >= 0 && !isNull(power(n, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
radians Numeric and mathematical
Client type: Not specified
Rule family: Custom (ADF/DSL)
Changes an angle from degrees to radians.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

radians(90.0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
radians(90.0)

Boolean row probe:
n >= 0 && !isNull(radians(90.0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
random Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Generates a pseudo-random number using an optional fixed seed and execution partition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: long

Result can depend on execution time, partition or generated values; consider rule reproducibility.

random(123)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
random(123)

Boolean row probe:
n >= 0 && !isNull(random(123))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
rank Window functions
Client type: Window
Rule family: Custom (ADF/DSL)
Assigns ranks to ordered values, leaving gaps after ties.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: integer

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

rank()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
rank()

Boolean row probe:
n >= 0 && !isNull(rank())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
reassociate Maps
Client type: Not specified
Rule family: Custom (ADF/DSL)
Produces a map with transformed values while preserving the key associations.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: map, binaryfunction
Declared minimum parameters: 2
Declared return type: map

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

reassociate(['alpha' -> 1, 'beta' -> 2], #value + 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
reassociate(['alpha' -> 1, 'beta' -> 2], #value + 1)

Boolean row probe:
n >= 0 && !isNull(reassociate(['alpha' -> 1, 'beta' -> 2], #value + 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"map","mapKeyType":{"typeString":"string"},"mapValueType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
reduce Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Folds array items into an accumulator using #acc and #item, then optionally shapes the result.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, any, binaryfunction, unaryfunction
Declared minimum parameters: 4
Declared return type: any

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

reduce([1, 2, 3], 0, #acc + #item, #result)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
reduce([1, 2, 3], 0, #acc + #item, #result)

Boolean row probe:
n >= 0 && !isNull(reduce([1, 2, 3], 0, #acc + #item, #result))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
regexExtract Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Returns a capture group from a regular-expression match; the documented default group is one.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string, integral
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

regexExtract(s, '([0-9]+)', 1)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
regexExtract(s, '([0-9]+)', 1)

Boolean row probe:
n >= 0 && !isNull(regexExtract(s, '([0-9]+)', 1))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
regexMatch Strings and pattern matching
Client type: General
Rule family: Custom; String format match
Tests text against a regular expression; use anchors when an entire-value match is required.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

regexMatch(s, '^[a-z]+$')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
regexMatch(s, '^[a-z]+$')

Boolean row probe:
n >= 0 && !isNull(regexMatch(s, '^[a-z]+$'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
regexReplace Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Replaces regular-expression matches with replacement text.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string, string
Declared minimum parameters: 3
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

regexReplace(s, '[0-9]', 'x')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
regexReplace(s, '[0-9]', 'x')

Boolean row probe:
n >= 0 && !isNull(regexReplace(s, '[0-9]', 'x'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
regexSplit Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Splits text into an array using a regular-expression separator.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

regexSplit(s, '[,;]')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
regexSplit(s, '[,;]')

Boolean row probe:
n >= 0 && !isNull(regexSplit(s, '[,;]'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"string"}}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
replace Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Replaces occurrences of literal text; omission of replacement text removes the matches.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string, string
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

replace(s, 'a', 'b')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
replace(s, 'a', 'b')

Boolean row probe:
n >= 0 && !isNull(replace(s, 'a', 'b'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
reverse Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Returns the characters of a string in reverse order.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

reverse(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
reverse(s)

Boolean row probe:
n >= 0 && !isNull(reverse(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
right Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Returns a requested number of characters from the end of text.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, integral
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

right(s, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
right(s, 2)

Boolean row probe:
n >= 0 && !isNull(right(s, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
rlike Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Tests text using a regular-expression pattern.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

rlike(s, '^[a-z]+$')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
rlike(s, '^[a-z]+$')

Boolean row probe:
n >= 0 && !isNull(rlike(s, '^[a-z]+$'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
round Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Rounds to an optional scale using an optional rounding mode; documented defaults are scale zero and half-up.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number, number, integral
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

round(x, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
round(x, 2)

Boolean row probe:
n >= 0 && !isNull(round(x, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
rowNumber Window functions
Client type: Window
Rule family: Custom (ADF/DSL)
Numbers rows sequentially from one within a window.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: integer

Purview explicitly excludes this function or its Window family, despite its presence in the client registry.

rowNumber()

ADF syntax illustration only: explicitly unsupported in Purview, even though the client accepts it.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
rowNumber()

Boolean row probe:
n >= 0 && !isNull(rowNumber())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Explicitly unsupported Client registry
Client description
ADF reference
rpad Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Pads the right side to a target length, or truncates text already longer than that target.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, integral, string
Declared minimum parameters: 3
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

rpad(s, 10, '0')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
rpad(s, 10, '0')

Boolean row probe:
n >= 0 && !isNull(rpad(s, 10, '0'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
rtrim Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Removes trailing whitespace, or trailing characters from a supplied set.
Evidence, signature metadata and caveats

Confidence rationale: Trailing-character behavior is supported by examples; the client phrase leading characters is a typo.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

rtrim(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
rtrim(s)

Boolean row probe:
n >= 0 && !isNull(rtrim(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
second Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Extracts the second component from a compatible date/time value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: timestamp, string
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

second(ts)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
second(ts)

Boolean row probe:
n >= 0 && !isNull(second(ts))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, ts

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
seconds Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Converts a quantity of seconds into a duration measured in milliseconds.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

seconds(2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
seconds(2)

Boolean row probe:
n >= 0 && !isNull(seconds(2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
setBitSet Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Enables the requested bit positions in a bitset.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, array
Declared minimum parameters: 2
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

setBitSet(toBitSet([1, 3]), [5])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
setBitSet(toBitSet([1, 3]), [5])

Boolean row probe:
n >= 0 && !isNull(setBitSet(toBitSet([1, 3]), [5]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sha1 Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Computes a SHA-1 fingerprint represented as hexadecimal text; not appropriate for modern cryptographic security.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

sha1(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sha1(s)

Boolean row probe:
n >= 0 && !isNull(sha1(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sha1Binary Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Appears to return a SHA-1 digest as binary rather than hexadecimal text, based on the declared return type.
Evidence, signature metadata and caveats

Confidence rationale: Binary return type contradicts copied hex-string prose; example invokes sha1 rather than sha1Binary.

Declared input types: any
Declared minimum parameters: 1
Declared return type: binary

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

sha1Binary(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
sha1Binary(s)

Boolean row probe:
n >= 0 && !isNull(sha1Binary(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"binary"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
No main ADF entry
sha2 Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Computes a SHA-2 fingerprint with a selected digest length.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer, any
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

sha2(256, s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sha2(256, s)

Boolean row probe:
n >= 0 && !isNull(sha2(256, s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sha2Binary Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Appears to return a SHA-2 digest as binary, based on its declared return type and example result.
Evidence, signature metadata and caveats

Confidence rationale: Binary return type is present; the example invokes sha2 rather than sha2Binary.

Declared input types: integer, any
Declared minimum parameters: 2
Declared return type: binary

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

sha2Binary(256, s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
sha2Binary(256, s)

Boolean row probe:
n >= 0 && !isNull(sha2Binary(256, s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"binary"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
No main ADF entry
sin Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the sine of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

sin(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sin(0.5)

Boolean row probe:
n >= 0 && !isNull(sin(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sinh Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the hyperbolic sine of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

sinh(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sinh(0.5)

Boolean row probe:
n >= 0 && !isNull(sinh(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
size Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Counts the elements in an array or entries in a map.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

size([1, 2, 3])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
size([1, 2, 3])

Boolean row probe:
n >= 0 && !isNull(size([1, 2, 3]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
skewness Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the skewness over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

skewness(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
skewness(x)

Boolean row probe:
n >= 0 && !isNull(skewness(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
skewnessIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the skewness using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

skewnessIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
skewnessIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(skewnessIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
slice Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Extracts a range from an array using a one-based starting position and optional length.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, integral, integral
Declared minimum parameters: 2
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

slice([1, 2, 3], 1, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
slice([1, 2, 3], 1, 2)

Boolean row probe:
n >= 0 && !isNull(slice([1, 2, 3], 1, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sort Arrays and collections
Client type: General
Rule family: Custom (ADF/DSL)
Orders array items with a comparison predicate using #item1 and #item2.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, binaryfunction
Declared minimum parameters: 2
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

sort([3, 1, 2], compare(#item1, #item2))

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sort([3, 1, 2], compare(#item1, #item2))

Boolean row probe:
n >= 0 && !isNull(sort([3, 1, 2], compare(#item1, #item2)))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
soundex Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Produces a phonetic Soundex code for text.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

soundex(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
soundex(s)

Boolean row probe:
n >= 0 && !isNull(soundex(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
split Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Splits text into an array using a literal separator.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

split(s, ',')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
split(s, ',')

Boolean row probe:
n >= 0 && !isNull(split(s, ','))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"string"}}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sqrt Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the square root of the input.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

sqrt(9.0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sqrt(9.0)

Boolean row probe:
n >= 0 && !isNull(sqrt(9.0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
startsWith Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Tests whether text begins with a specified prefix.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

startsWith(s, 'a')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
startsWith(s, 'a')

Boolean row probe:
n >= 0 && !isNull(startsWith(s, 'a'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
stddev Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the standard deviation over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

stddev(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
stddev(x)

Boolean row probe:
n >= 0 && !isNull(stddev(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
stddevIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the standard deviation using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

stddevIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
stddevIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(stddevIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
stddevPopulation Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the population standard deviation over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

stddevPopulation(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
stddevPopulation(x)

Boolean row probe:
n >= 0 && !isNull(stddevPopulation(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
stddevPopulationIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the population standard deviation using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

stddevPopulationIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
stddevPopulationIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(stddevPopulationIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
stddevSample Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the sample standard deviation over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

stddevSample(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
stddevSample(x)

Boolean row probe:
n >= 0 && !isNull(stddevSample(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
stddevSampleIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the sample standard deviation using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

stddevSampleIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
stddevSampleIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(stddevSampleIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
subDays Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Moves a date or timestamp backward by a given number of days, not months.
Evidence, signature metadata and caveats

Confidence rationale: Corrected using the public day-subtraction signature and example; the client description says months.

Declared input types: datetime, integral
Declared minimum parameters: 2
Declared return type: datetime

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

subDays(d, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
subDays(d, 2)

Boolean row probe:
n >= 0 && !isNull(subDays(d, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"date"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
subMonths Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Moves a date or timestamp backward by a given number of months.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime, integral
Declared minimum parameters: 2
Declared return type: datetime

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

subMonths(d, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
subMonths(d, 2)

Boolean row probe:
n >= 0 && !isNull(subMonths(d, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"date"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
substring Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Extracts text from a one-based position, optionally limited to a specified length.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, integral, integral
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

substring(s, 2, 3)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
substring(s, 2, 3)

Boolean row probe:
n >= 0 && !isNull(substring(s, 2, 3))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sum Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the sum over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: number

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

sum(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sum(x)

Boolean row probe:
n >= 0 && !isNull(sum(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sumDistinct Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Adds distinct numeric values once each.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: number

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

sumDistinct(n)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sumDistinct(n)

Boolean row probe:
n >= 0 && !isNull(sumDistinct(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sumDistinctIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Likely adds distinct numeric values from qualifying rows; the source prose omits the distinctness semantics.
Evidence, signature metadata and caveats

Confidence rationale: Distinctness is inferred from the function name and sibling; neither description nor example establishes duplicate handling.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: number

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

sumDistinctIf(flag, n)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
Low Accepted (client)
Exact expression and result

Function probe:
sumDistinctIf(flag, n)

Boolean row probe:
n >= 0 && !isNull(sumDistinctIf(flag, n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n, flag

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
sumIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the sum using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: number

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

sumIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
sumIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(sumIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
tan Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the tangent of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

tan(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
tan(0.5)

Boolean row probe:
n >= 0 && !isNull(tan(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
tanh Numeric and mathematical
Client type: General
Rule family: Custom (ADF/DSL)
Computes the hyperbolic tangent of a number.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

tanh(0.5)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
tanh(0.5)

Boolean row probe:
n >= 0 && !isNull(tanh(0.5))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toBase64 Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Encodes text as Base64.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toBase64(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toBase64(s)

Boolean row probe:
n >= 0 && !isNull(toBase64(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toBinary Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts a supported numeric, date/time or string value into a binary representation.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any
Declared minimum parameters: 1
Declared return type: binary

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toBinary(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toBinary(s)

Boolean row probe:
n >= 0 && !isNull(toBinary(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"binary"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toBitSet Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Builds a bitset from supplied bit positions; the shipped required-argument count conflicts with its one-argument example.
Evidence, signature metadata and caveats

Confidence rationale: Client-only description. Metadata requires two arguments but supplies one input type and a one-argument example.

Declared input types: array
Declared minimum parameters: 2
Declared return type: array

Minimum parameter count exceeds the listed input-type count; treat the signature metadata as inconsistent.

toBitSet([1, 3])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
toBitSet([1, 3])

Boolean row probe:
n >= 0 && !isNull(toBitSet([1, 3]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
No main ADF entry
toBoolean Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts recognized true/false text tokens to Boolean; unrecognized tokens produce null.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toBoolean('true')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toBoolean('true')

Boolean row probe:
n >= 0 && !isNull(toBoolean('true'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toByte Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts a numeric or string value to a byte, optionally using a numeric format.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string
Declared minimum parameters: 1
Declared return type: byte

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toByte('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toByte('12')

Boolean row probe:
n >= 0 && !isNull(toByte('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"byte"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toDate Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Parses a date, optionally using a specified date format.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string
Declared minimum parameters: 1
Declared return type: date

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toDate('2026-09-16')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toDate('2026-09-16')

Boolean row probe:
n >= 0 && !isNull(toDate('2026-09-16'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"date"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
toDecimal Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts a value to decimal with optional precision, scale, format and locale; the documented default is decimal(10,2).
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, integral, integral, string, string
Declared minimum parameters: 1
Declared return type: decimal

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toDecimal(x, 10, 2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toDecimal(x, 10, 2)

Boolean row probe:
n >= 0 && !isNull(toDecimal(x, 10, 2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"decimal","precision":10,"scale":2}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toDouble Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts a numeric or string value to double precision, optionally using a format and locale.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string
Declared minimum parameters: 1
Declared return type: double

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toDouble('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toDouble('12')

Boolean row probe:
n >= 0 && !isNull(toDouble('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toFloat Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts a numeric or string value to single precision; precision can be lost.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string
Declared minimum parameters: 1
Declared return type: float

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toFloat('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toFloat('12')

Boolean row probe:
n >= 0 && !isNull(toFloat('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"float"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toInteger Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts a numeric or string value to an integer; fractional portions can be truncated.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toInteger('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toInteger('12')

Boolean row probe:
n >= 0 && !isNull(toInteger('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toLong Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts a numeric or string value to a long integer; fractional portions can be truncated.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toLong('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toLong('12')

Boolean row probe:
n >= 0 && !isNull(toLong('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
toShort Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Converts a numeric or string value to a short integer; narrowing can lose information.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string
Declared minimum parameters: 1
Declared return type: short

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toShort('12')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toShort('12')

Boolean row probe:
n >= 0 && !isNull(toShort('12'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"short"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
toString Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Formats a primitive value as text, with optional numeric or date/time formatting.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toString(n)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toString(n)

Boolean row probe:
n >= 0 && !isNull(toString(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
toTimestamp Conversion and type checks
Client type: General
Rule family: Custom (ADF/DSL)
Parses a timestamp with optional format and timezone; the documentation specifies millisecond precision.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: any, string, string, string
Declared minimum parameters: 1
Declared return type: timestamp

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toTimestamp('2026-09-16 12:00:00')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toTimestamp('2026-09-16 12:00:00')

Boolean row probe:
n >= 0 && !isNull(toTimestamp('2026-09-16 12:00:00'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"timestamp"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
toUTC Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Converts a timestamp from a specified or default timezone to UTC.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: timestamp, string
Declared minimum parameters: 1
Declared return type: timestamp

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

toUTC(ts, 'Europe/Berlin')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
toUTC(ts, 'Europe/Berlin')

Boolean row probe:
n >= 0 && !isNull(toUTC(ts, 'Europe/Berlin'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"timestamp"}
Inferred row type: boolean
Row column references: n, ts

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
translate Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Replaces individual characters according to paired source and destination character sets.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string, string
Declared minimum parameters: 3
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

translate(s, 'ab', 'xy')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
translate(s, 'ab', 'xy')

Boolean row probe:
n >= 0 && !isNull(translate(s, 'ab', 'xy'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
trim Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Removes whitespace at both ends, or characters from a supplied trim set.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

trim(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
trim(s)

Boolean row probe:
n >= 0 && !isNull(trim(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
true Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Produces the Boolean constant true.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

true()

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
true()

Boolean row probe:
n >= 0 && !isNull(true())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
type Metadata and expression helpers
Client type: Not specified
Rule family: Custom (ADF/DSL)
Returns a schema-style type description for a column/expression, or null when the column is missing.
Evidence, signature metadata and caveats

Confidence rationale: Client-only schema-type description and examples; not executed.

Declared input types: any
Declared minimum parameters: 1
Declared return type: string

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule. The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

type(n)

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
Medium Accepted (client)
Exact expression and result

Function probe:
type(n)

Boolean row probe:
n >= 0 && !isNull(type(n))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
No main ADF entry
typeMatch Metadata and expression helpers
Client type: General
Rule family: Custom (ADF/DSL)
Checks column types inside a column-pattern expression; it is not a general-purpose row datatype check.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: boolean

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule.

typeMatch('integer', 'number')

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
typeMatch('integer', 'number')

Boolean row probe:
n >= 0 && !isNull(typeMatch('integer', 'number'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
unescape Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Reverses escaping for a supported named text format.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string, string
Declared minimum parameters: 2
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

unescape(s, 'json')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
unescape(s, 'json')

Boolean row probe:
n >= 0 && !isNull(unescape(s, 'json'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
unfold Arrays and collections
Client type: Not specified
Rule family: Custom (ADF/DSL)
Expands array items into rows while repeating the other columns; it requires a row-expansion context.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array
Declared minimum parameters: 1
Declared return type: any

Depends on ADF stream, schema, transformation or assertion context; client presence alone does not establish usability in a DQ row rule. The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

unfold([1, 2, 3])

Context-dependent example: may require stream, schema or transformation context not available in a Purview row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
unfold([1, 2, 3])

Boolean row probe:
n >= 0 && !isNull(unfold([1, 2, 3]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"integer"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Context-dependent; untested Client registry
Client description
ADF reference
unhex Hashing and bit operations
Client type: General
Rule family: Custom (ADF/DSL)
Decodes hexadecimal text into binary data.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: binary

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

unhex('616263')

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
unhex('616263')

Boolean row probe:
n >= 0 && !isNull(unhex('616263'))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"binary"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
union Arrays and collections
Client type: Not specified
Rule family: Custom (ADF/DSL)
Combines two arrays and removes duplicate items.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: array, array
Declared minimum parameters: 2
Declared return type: array

The shipped functionType field is absent. The functional group is an editorial classification, not an API category.

union([1, 2], [2, 3])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
union([1, 2], [2, 3])

Boolean row probe:
n >= 0 && !isNull(union([1, 2], [2, 3]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
upper Strings and pattern matching
Client type: General
Rule family: Custom (ADF/DSL)
Changes text to uppercase.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: string
Declared minimum parameters: 1
Declared return type: string

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

upper(s)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
upper(s)

Boolean row probe:
n >= 0 && !isNull(upper(s))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n, s

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
uuid Execution and row-state helpers
Client type: General
Rule family: Custom (ADF/DSL)
Generates a UUID.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: (none)
Declared minimum parameters: 0
Declared return type: string

Result can depend on execution time, partition or generated values; consider rule reproducibility.

uuid()

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
uuid()

Boolean row probe:
n >= 0 && !isNull(uuid())

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"string"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
values Maps
Client type: General
Rule family: Custom (ADF/DSL)
Returns the values of a map.
Evidence, signature metadata and caveats

Confidence rationale: Client description and array-returning map examples agree; no main ADF entry found.

Declared input types: map
Declared minimum parameters: 1
Declared return type: array

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

values(['alpha' -> 1, 'beta' -> 2])

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
values(['alpha' -> 1, 'beta' -> 2])

Boolean row probe:
n >= 0 && !isNull(values(['alpha' -> 1, 'beta' -> 2]))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"array","arrayType":{"typeString":"any"}}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
No main ADF entry
variance Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the variance over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

variance(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
variance(x)

Boolean row probe:
n >= 0 && !isNull(variance(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Purview-documented; untested Client registry
Client description
ADF reference
varianceIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the variance using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

varianceIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
varianceIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(varianceIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
variancePopulation Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the population variance over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

variancePopulation(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
variancePopulation(x)

Boolean row probe:
n >= 0 && !isNull(variancePopulation(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
variancePopulationIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the population variance using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

variancePopulationIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
variancePopulationIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(variancePopulationIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
varianceSample Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the unbiased sample variance over the aggregation group.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: number
Declared minimum parameters: 1
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

varianceSample(x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
varianceSample(x)

Boolean row probe:
n >= 0 && !isNull(varianceSample(x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
varianceSampleIf Aggregate and statistical
Client type: Aggregate
Rule family: Custom (ADF/DSL)
Computes the unbiased sample variance using only rows satisfying a supplied condition.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, number
Declared minimum parameters: 2
Declared return type: double

Aggregates operate over a group; do not assume ordinary per-row evaluation or an implicit grouping contract.

varianceSampleIf(flag, x)

Aggregate example: evaluates across a group, not a single row. Purview grouping behavior remains unverified.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
varianceSampleIf(flag, x)

Boolean row probe:
n >= 0 && !isNull(varianceSampleIf(flag, x))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"double"}
Inferred row type: boolean
Row column references: n, flag, x

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
weekOfYear Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Returns the input date's week-of-year number; boundary conventions should be confirmed for your use case.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

weekOfYear(d)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
weekOfYear(d)

Boolean row probe:
n >= 0 && !isNull(weekOfYear(d))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
weeks Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Converts a quantity of weeks into a duration measured in milliseconds.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: integer
Declared minimum parameters: 1
Declared return type: long

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

weeks(2)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
weeks(2)

Boolean row probe:
n >= 0 && !isNull(weeks(2))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"long"}
Inferred row type: boolean
Row column references: n

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
xor Logic and null handling
Client type: General
Rule family: Custom (ADF/DSL)
Returns true when exactly one Boolean input is true.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: boolean, boolean
Declared minimum parameters: 2
Declared return type: boolean

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

xor(flag, n > 0)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
xor(flag, n > 0)

Boolean row probe:
n >= 0 && !isNull(xor(flag, n > 0))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"boolean"}
Inferred row type: boolean
Row column references: n, flag

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference
year Dates, times and durations
Client type: General
Rule family: Custom (ADF/DSL)
Extracts the year component from a compatible date/time value.
Evidence, signature metadata and caveats

Confidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test.

Declared input types: datetime
Declared minimum parameters: 1
Declared return type: integer

No additional context-specific caveat recorded; this does not establish null or edge-case behavior.

year(d)

Expression example; combine with a comparison or Boolean condition for a custom row rule.

Example column definitions
High Accepted (client)
Exact expression and result

Function probe:
year(d)

Boolean row probe:
n >= 0 && !isNull(year(d))

Expected: No parser/type diagnostics; row probe has Boolean type. No output value was expected or evaluated.

Function diagnostics: No diagnostics

Row diagnostics: No diagnostics

Inferred function type: {"typeString":"integer"}
Inferred row type: boolean
Row column references: n, d

Scope: Direct invocation of the production client validator with synthetic column definitions, not a saved rule, UI save test, server validation or data scan.

Client-listed; untested Client registry
Client description
ADF reference

Coverage, exclusions and API provenance

Explicit exclusions: Purview documentation excludes isDelete, isError, isIgnore, isInsert, isMatch, isUpdate, isUpsert, partitionId, cached lookup and Window functions. The eight named entries plus seven Window entries are retained in this catalogue with an unsupported flag so their client presence cannot be mistaken for support.

ADF-only inventory differences: Fourteen functions have entries in the public reference but were absent from this client registry: ascii, assertErrorMessages, char, collectUnique, countAll, countAllDistinct, decode, encode, lookup, mlookup, output, outputs, substringIndex, topN. Their absence is not, by itself, proof of runtime rejection. They are deliberately not added to the 259-function total.

API result: The documented 2026-01-12-preview Get Rules request returned HTTP 200 with an empty rule collection for the inspected existing asset. No function-enumeration operation is documented in the supplied operation-group index. The descriptions and signatures here came from client metadata, not from that empty API response. Internal portal requests were observed read-only and should not be treated as supported public API contracts.

GET {endpoint}/datagovernance/quality/business-domains/{domainId}
    /data-products/{productId}/data-assets/{assetId}/rules
    ?api-version=2026-01-12-preview
Authorization: Bearer {token for https://purview.azure.net}

The line breaks above are for readability. Use the Unified Catalog/data-quality permissions appropriate to the operation; the tutorial's Data Map tab is not a complete DQ authorization guide. Existing access worked, so no service principal or secret was created.

Sources and reproducibility
  1. Purview rule families, expression language and explicit exclusions.
  2. Public API operation groups and Get Rules contract.
  3. Data-plane authentication tutorial.
  4. ADF alphabetical function reference: 264 function sections inspected, 250 matching the 259 client entries.
  5. General, Conversion, Map, and Metafunction summary references.
  6. Shipped Purview DSL registry: module 12966, exported dsl.functions. The expression-builder component consumes this object. SHA-256: 323b7f3fcbe0874379b761092373272ddd16a91c15297ae970feaf586d3a012d.
  7. Shipped English description metadata: languages.dsl.functionDescriptions. SHA-256: 886f8d848cb24d1789b20024017e3c2c778087708c08162e06449d7fdb0f438d.

The initial registry extraction parsed literal data without executing bundle code. The subsequent no-scan checks loaded the production editor module in the existing Purview browser session and invoked only its local parser/type validator, not its function evaluator. Every registry entry had a description key and an English description. Raw client categories were preserved, including missing values; no undocumented server catalogue endpoint was invented. Versioned assets may be retired later, and a different client build may expose a different inventory.