databrickslabs / databrickslabs/ontos
[Feature]: Integrate DQX for DQ checks of Data Contracts
Nobody has claimed this yet.
- Dominant language
- Python
- Stars
- 212
- Forks
- 71
- Avg merge
- 4d 10h
- Merged PRs (30d)
- 43
Description
Is there an existing issue for this?
- I have searched the existing issues
Problem statement
Contracts can define DQ rules, they have to be implement somehow.
Proposed Solution
Use DQX to implement the DQ rules and surface the findings via the Ontos UI. The Compliance service defines one or more compliance check for every active contract. These are run as jobs on a Databricks job cluster (configured in the settings), and have a UI to view all recent job runs and the results of them.
DQX supports summary tables that can be used to show results for large operations (think 1T row scan) instead of listing all violations separately. For up to certain number of rows the option is to show both, the summary and the individual violations.
Additional Context
No response
Contributor guide
First steps
- Read the whole issue, then the project's contributing guide.
- Comment on the issue to say you are picking it up — it saves two people doing the same work.
- Fork the repository and make your change on a branch.
- Open a pull request that references the issue number.
Research direction
Start by mapping the Compliance service, DQX integration, Databricks job-cluster configuration, and Ontos UI described in the proposal. Define how checks run for each active contract, how job runs and results are displayed, and when summary versus individual violations are shown. Done means the end-to-end design and implementation support these workflows.
Written by the indexing model from the issue text.
Assessment
- Tech stack
- python
- Domain
- backend, data-engineering, frontend
- Issue type
- Feature
- Difficulty
- 5/5
- Estimated time
- Over a week
- Activity status
- Stale
- Clarity
- Needs clarification
- Newbie friendliness
- 25/100