“Which inspection results actually count as passed?”
The pass rate depends on which inspection records belong in the denominator. Duodata connects the agreed definition to the inspection tables and deploys it as native semantics in Databricks or Snowflake, so AI answers with the rule your quality team owns.
For quality and operations teams · Quality · Operations · Finance
Inspection pass rate, two definitions
The agreed definition becomes an explicit mapping: which table holds inspections, which values count as passed, and how conditionals are treated. That mapping deploys as a Unity Catalog metric view or a Snowflake semantic view — in your account, your Git and your release process.
| Business term | Source | Note |
|---|---|---|
| Inspection | qms.inspections | One row per closed inspection in the reporting window. |
| Passed | qms.inspections.result = 'PASS' | Final result after any conditional period resolves. |
| Conditional | qms.inspections.result = 'CONDITIONAL' | Included or excluded per the agreed definition. |
| Reporting window | qms.inspections.closed_date | Calendar quarter, owned by Quality. |
- Observed schema of the quality tables, kept distinct from the business definition
- Business-term mapping: passed, conditional, reporting window → physical columns
- Native output: metric view (Databricks) or semantic view (Snowflake)
- Definition changes reviewed once, then carried through with lineage
Illustrative mapping with fictional tables. Website examples do not execute in your warehouse.
Put this meaning to work in your platform.
Databricks
The agreed definition deploys as Unity Catalog metric views, answered by AI/BI Genie.
Snowflake
The agreed definition deploys as Semantic Views, answered by Cortex Analyst.
Start a free pilot
We work through one business question with you: agree its meaning, map it to the relevant data and review how it works on Snowflake or Databricks. We agree the scope together before we start.
- 01One business question
- 02One owner of the definition
- 03The data it depends on
- 04A review on your platform
- Start a free pilotWatch demo