[Wranglers] Data Quality checks in Snowflake using Data Metric Functions

[Ali, Saqib]

A detailed article on Tackling Data Quality Challenges Using Data Metric
Functions in Snowflake by Sandamali De Zoysa
https://medium.com/@sdezoysa/tackling-data-quality-challenges-using-data-metric-functions-in-snowflake-a62593effbc6

Good read and excellent example.

On Sun, Mar 31, 2024 at 6:52 PM Ali, Saqib <docbook.xml at gmail.com> wrote:

> Data Metrics Functions (DMF) are here! DMFs allow you to automate data
> quality validation and monitoring in Snowflake. Snowflake has several
> Pre-defined DMFs like NULL_COUNT, DUPLICATE_COUNT, UNIQUE_COUNT, FRESHNESS,
> ROW_COUNT. If you need something more advanced, you can roll your own
> custom Data Metric Functions. Creating custom DMFs is as easy as creating
> UDFs and then attaching them to tables as follows. Sample SQL available on
> GitHub:
> https://qosf.com/data-metric-function-in-snowflake.html
>
> Thanks,
> Saqib
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://analyticsengineering.net/pipermail/wranglers/attachments/20240401/1d5ef180/attachment.htm>