DQOps is an DataOps friendly data quality monitoring platform with customizable data quality checks and data quality dashboards. DQOps comes with around 150 predefined data quality checks which helps you monitor the quality of your data.
To use DQOps you need:
DQOps is available on PyPi repository.
To install DQOps via pip manager just run
python -m pip install --user dqops
If you prefer to work with the source code, just clone our GitHub repository https://github.com/dqops/dqo and run
Run dqops module to finalize the installation.
python -m dqops
Create DQOps user home folder.
After installation, you will be asked whether to initialize the DQO user's home folder in the default location. Type Y to create the folder.
The user's home folder locally stores data such as sensor readouts and the data quality check results, as well as data source configurations. You can learn more about data storage here.
Login to DQOps Cloud.
To use DQOps features, such as storing data quality definitions and results in the cloud or data quality dashboards, you must create a DQOps cloud account.
After creating a user's home folder, you will be asked whether to log in to the DQO cloud. After typing Y, you will be redirected to https://cloud.dqops.com/registration, where you can create a new account, use Google single sign-on (SSO) or log in if you already have an account.
During the first registration, a unique identification code (API Key) will be generated and automatically retrieved by DQO application. The API Key is now stored in the configuration file.
Open the DQOps User Interface Console in your browser by CTRL-clicking on the link displayed on the command line (for example http://localhost:8888) or by copying the link.
DQOps is designed as the primary platform for data quality teams, and for all data engineering or data science teams who want to apply data quality for their data platforms.
The following list shows selected use cases, with examples and best practices.
The definition of data quality KPIs describes the formulas used by DQOps to calculate a data quality score, used to measure the quality of data sources
You will learn how to create custom data quality dashboards using a custom connector for Looker Studio provided by DQOps. Your data quality dashboards will show the data quality results organized in a format that is easy to understand by your business sponsors.
Look at the categories of data quality checks that are supported by DQOps.
Learn how to detect timeliness and freshness with DQOps.
Learn how to measure data quality incrementally using time partitioned checks that are a unique feature of DQOps, allowing the analysis of financial data, append-only data, or very big tables at a terabyte or petabyte scale.
Similar data quality issues are grouped into data quality incidents, learn how grouping data quality issues to incidents, and how to receive notifications using Slack or passed to a webhook.
The following examples also show the whole process of configuring data quality checks, both using YAML files, or using the DQOps user interface.
Learn how to detect database and table availability issues.
Learn how to configure data volume checks to detect empty or incomplete tables.
Detect if columns contain only accepted values.
Detect duplicate values in columns by measuring the percentage of duplicates.
Validate values in text columns using a regular expression to detect values that are invalid emails.
Use schema drift data quality checks to detect table schema changes, such as missing columns, column order change, column data type change, or just that new columns were added or removed from a table.
You can integrate DQOps into data pipelines and ML pipelines by calling a Python client for DQOps. Install the client as a Python package:
python -m pip install --user dqops
The dqops package contains a remote client that can connect to a DQOps instance and perform all operations supported by the user interface.
The DQOps client could be used inside data pipelines or data preparation code to verify the quality of tables.
You can use the unauthenticated client to connect to a local DQOps instance from your data pipeline code. First, create the client object.
from dqops import client
dqops_client = client.Client(base_url="http://localhost:8888")
Alternatively, if you are connecting to a production instance of DQOps that has authentication
enabled, you have to open the user's profile screen in DQOps and generate your DQOps API Key.
Then take the key and use it as the token, when creating an AuthenticatedClient instead.
from dqops import client
dqops_client = client.AuthenticatedClient(base_url="http://localhost:8888", token="Your DQO API Key")
Now, you can call operations on DQOps. The following code shows how to execute data quality checks on data sources that are already registered in DQOps.
from dqops.client.api.jobs import run_checks
from dqops.client.models import CheckSearchFilters, \
RunChecksParameters
request_body = RunChecksParameters(
check_search_filters=CheckSearchFilters(
column='sample_column',
column_data_type='string',
connection='sample_connection',
full_table_name='sample_schema.sample_table',
enabled=True
)
)
check_results = run_checks.sync(
client=dqops_client,
json_body=request_body
)
The run_checks operation returns a summary of executed data quality checks and the highest
data quality issue severity level. In the following example, the most severe issue was at an error severity level.
{
"jobId" : {
"jobId" : 123456789,
"createdAt" : "2023-10-11T13:42:00Z"
},
"result" : {
"highest_severity" : "error",
"executed_checks" : 10,
"valid_results" : 7,
"warnings" : 1,
"errors" : 2,
"fatals" : 0,
"execution_errors" : 0
},
"status" : "finished"
}
Learn more about the DQOps Python client in the DQOps REST API client reference documentation that shows Python code examples for every operation supported by the client.
For full documentation with guides and use cases, visit https://dqops.com/docs/
The getting started guide shows how to start using DQOps.
Also, read the DQOps concept guide to know how DQOps operates, and how to configure data quality checks.
If you find any issues with the tool, just post it here:
https://github.com/dqops/dqo/issues
or contact us via https://dqops.com/
FAQs
DQOps Data Quality Operations Center
We found that dqops demonstrated a healthy version release cadence and project activity because the last version was released less than a year ago. It has 1 open source maintainer collaborating on the project.
Did you know?
Socket for GitHub automatically highlights issues in each pull request and monitors the health of all your open source dependencies. Discover the contents of your packages and block harmful activity before you install or update your dependencies.
Security News
PyPI confirms no security flaws were exploited in the Ultralytics supply chain attack and highlights improvements for safer package publishing.
Security News
Research
The Socket Research Team breaks down a malicious wrapper package that uses obfuscation to harvest credentials and exfiltrate sensitive data.
Research
Security News
Attackers used a malicious npm package typosquatting a popular ESLint plugin to steal sensitive data, execute commands, and exploit developer systems.