Set up SMTP
We've moved! To improve customer experience, the Collibra Data Quality User Guide has moved to the Collibra Documentation Center as part of the Collibra Data Quality 2022.11 release. To ensure a seamless transition, dq-docs.collibra.com will remain accessible, but the DQ User Guide is now maintained exclusively in the Documentation Center.
Simple Mail Transport Protocol or SMTP, is an internet standard for email transmission. Collibra DQ allows you to configure a single SMTP server to send alerts to the attention of the dataset owner in case a specific condition is met, such as:
- Owl Data Quality Score is below a specific threshold.
- Row Count is below a specific threshold.
- If a rule is triggered.
- 1.In the Admin Console, click Alerts.
- 2.In the Configuration section, enter the required information:
The name or the IP address of the SMTP server.
The port used by the SMTP server.
The username or the account that is configured on the SMTP server for use.
The password of the SMTP server username or account.
(Default) To Email
The sender email address.
The reply-to email address.
Save your changes.
SMTP setup in Collibra DQ Admin Console
See screenshot below for example of configuration.
When completed click the “Add” button.
Once the information has been populated and added, the grey box above the form will get populated with the content supplied. If the data ever has to be changed clicking the
icon will repopulate the form in order to be modified and re added.
Now that configuration of the SMTP Email Server has been completed let’s create an alert and see that the alert triggers an email. In this example, we will use the dist_example dataset that we ran earlier from the demo.sh script.
In the above screen shot we did the following:
- 1.Searched for the “dist_example” dataset
- 2.Provided an alert named “score_lt_90”
- 3.Provided a condition that we know will be met “score < 90”
- 5.Custom Message = “score is below 90 for dist_exampe”
Clicking the “Save” button will move the contents of the form above to the List of Alerts for this particular dataset.
From the terminal on this install if you run the below command (which is just an extract out of the demo.sh file). We should see the alert get triggered
./owlcheck -ds dist_example -rd 2018-10-07 -d , -f /opt/owl/bin/demos/distribution_change.csv -fq "select * from dataset where d_date ='2018-10-07'"
At the end of this command we should see the “Alert was triggered” as shown in the screenshot below.