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.
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 family | Description | Important behavior | Description confidence |
|---|---|---|---|
| Freshness | Checks 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 values | Checks that individual column values are unique. | Null/empty treatment depends on whether an Empty/blank fields rule is defined. | High |
| String format match | Validates 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 match | Checks values against the rule engine's expected datatype. | Uses the ADF-derived type system rather than source-native SQL type names. | High |
| Duplicate rows | Checks uniqueness of a combination of column values. | The documentation permits at most one instance per asset. | High |
| Empty/blank fields | Requires populated values; strings must not be empty or whitespace-only. | This is stricter than notNull(), which permits an empty string. | High |
| Table lookup | Checks 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
| Function | Conflict and treatment |
|---|---|
| fromBase64 | Client text says encode. Public signature/examples establish decode; description corrected. |
| subDays | Client text says subtract months. Public signature/examples establish days; description corrected. |
| least | Client and public prose describe a comparison operator, but their examples return the minimum value. Medium confidence. |
| md5Binary, sha1Binary, sha2Binary, blake2bBinary | Return types say binary, while some prose and examples are copied from non-binary siblings. Binary-output descriptions are qualified. |
| crc32 | Text contains SHA-like bit-length choices. The catalogue describes the checksum without asserting those choices as a valid CRC parameter. |
| toBitSet | Minimum-argument count is two, but the declared inputs and example contain one argument. |
| sumDistinctIf | The name suggests conditional distinct summation, but the prose/examples do not establish duplicate treatment. Low confidence. |
| isUpsert | The name suggests upsert while the prose says insert. Low confidence, and explicitly unsupported in Purview. |
| mapAssociation | The public signature and example clarify that the result is an array, unlike reassociate, which returns a map. |
| jaroWinkler | Called 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.
| Column | Type | Illustrative value |
|---|---|---|
n | integer | 3 |
x | double | 12.5 |
y | double | 4.0 |
s | string | 'alpha' |
flag | boolean | true |
d | date | 2026-09-16 |
ts | timestamp | 2026-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
| Function | Categories | Description and caveats | Example | Description confidence | Client validation | Runtime 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Digest purpose is clear; declared minimum arguments is one despite examples taking bit length and input. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Binary return type is present, but the example and minimum-argument metadata are inconsistent. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: CRC-32 purpose is clear, but both sources contain suspect SHA-style bit-length text. Signature details are not asserted. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Case-insensitive comparison is documented, but operator spellings differ across shipped metadata; use the function name. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Corrected using the public decoding example; the client description says encoding. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Client-only evidence; text and examples do not establish assignment direction precisely. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Aggregate distinctness is described, but exact group-versus-row scoring behavior in Purview was not established. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: The name implies upsert, but both descriptions say insert; also explicitly unsupported in Purview. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Sources call this distance, but the identical-string example returns 1.0, indicating a similarity-style score. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Client description and array-returning map examples agree; no main ADF entry found. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Client and public prose incorrectly describe <=; both examples instead return the minimum value. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Wildcard semantics are documented, but escape-character wording differs between sources; no escape character is prescribed here. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Public signature and example resolve the client description: this returns an array, not a map. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 definitionsThe integer conversion avoids the client type diagnostic on arithmetic with #index. |
High | Accepted (client)
Exact expression and resultFunction probe: Boolean row probe: 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: Earlier attempt retained: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Binary return type contradicts copied hex-string prose; example invokes md5 rather than md5Binary. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Unicode decomposition is described; exact normalization form and edge behavior are unspecified. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Client description, Boolean return type and explicit null/empty-string examples agree; no main ADF entry found. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 definitionsUse inside a surrounding expression such as isNull(null()); a standalone null value receives a client diagnostic. |
High | Accepted (client)
Exact expression and resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Trailing-character behavior is supported by examples; the client phrase leading characters is a typo. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Binary return type contradicts copied hex-string prose; example invokes sha1 rather than sha1Binary. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Binary return type is present; the example invokes sha2 rather than sha2Binary. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Corrected using the public day-subtraction signature and example; the client description says months. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Distinctness is inferred from the function name and sibling; neither description nor example establishes duplicate handling. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Client-only description. Metadata requires two arguments but supplies one input type and a one-argument example. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Client-only schema-type description and examples; not executed. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Client description and array-returning map examples agree; no main ADF entry found. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 caveatsConfidence rationale: Purpose is described in the shipped client metadata and in the public ADF reference; no Purview execution test. Declared input types: 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 resultFunction probe: Boolean row probe: 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: 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 |
No functions match these filters.
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
- Purview rule families, expression language and explicit exclusions.
- Public API operation groups and Get Rules contract.
- Data-plane authentication tutorial.
- ADF alphabetical function reference: 264 function sections inspected, 250 matching the 259 client entries.
- General, Conversion, Map, and Metafunction summary references.
- Shipped Purview DSL registry: module 12966, exported
dsl.functions. The expression-builder component consumes this object. SHA-256:323b7f3fcbe0874379b761092373272ddd16a91c15297ae970feaf586d3a012d. - 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.