Skilirium

7. etapp: Andmekvaliteedi reeglite tuletamine

Kompetentsi Andmete modelleerimine knobit · K-717 · Oskus

Recognises a check expression unable to run

Mida see tähendab

An expression in logical names or business terms rather than physical column names, in another dialect's syntax, or reading columns the rule does not cite. It either errors — and an erroring check is often counted as passing — or runs against something else.

Kuidas seda hinnatakse

Flags the deficient case and passes the acceptable one. Deficient: `"Makse summa" <= "Kontojääk"` against a table whose columns are `makse_summa` and `kontojaak`; or Postgres `~` regex on a Snowflake target Acceptable: `makse_summa <= kontojaak`, with both columns in `columns`; dialect-specific syntax noted in `comment` (`DQR-010`, `DQR-020`)

Tugineb

Vajalik

  • Puudub