databrickslabs / databrickslabs/ontos

[Feature]: Integrate DQX for DQ checks of Data Contracts

Open
#8 0 comments 0 reactions 0 assignees View on GitHub

Nobody has claimed this yet.

scope/compliance scope/contracts type/feature
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

Open the contributing guide

First steps

  1. Read the whole issue, then the project's contributing guide.
  2. Comment on the issue to say you are picking it up — it saves two people doing the same work.
  3. Fork the repository and make your change on a branch.
  4. 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

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.