Knobit of Data modelling · K-811 · Skill

Recognises a reserved word used as an identifier

What it means

A table or column name that is reserved on one of the configured targets. It can quote cleanly on four engines and fail on the fifth, or deploy everywhere and break the first hand-written query.

How it is assessed

Flags the deficient case and passes the acceptable one. Deficient: A `dim_party` column named `current` for the current relationship owner: reserved in ISO 9075 and in Postgres Acceptable: `is_current_relationship`, with the reserved-word check run against every configured dialect rather than only the development one (`PHY-012`)

Builds on

Explains SQL dialect differencesK-852 · Knowledge
Explains naming conventions for data model objectsK-919 · Knowledge

Needed by

None