[Analytics Engineering] Data Quality checks in Snowflake using Data Metric Functions
Ali, Saqib docbook.xml at gmail.com
Mon Apr 1 14:34:16 UTC 2024
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>
- Previous message (by thread): [Wranglers] Data Quality checks in Snowflake using Data Metric Functions
- Next message (by thread): [Wranglers] Snowflake Tag-based masking policies in DBT