mirror of
https://github.com/datahub-project/datahub.git
synced 2025-07-04 23:57:03 +00:00
77 lines
2.2 KiB
YAML
77 lines
2.2 KiB
YAML
![]() |
version: 1
|
||
|
namespace: test-config-id-1
|
||
|
assertions:
|
||
|
# Freshness Assertion
|
||
|
- entity: urn:li:dataset:(urn:li:dataPlatform:snowflake,test_db.public.test_assertions_all_times,PROD)
|
||
|
type: freshness
|
||
|
lookback_interval: "1 hour"
|
||
|
last_modified_field: col_timestamp
|
||
|
schedule:
|
||
|
type: cron
|
||
|
cron: 0 * * * *
|
||
|
meta:
|
||
|
entity_qualified_name: TEST_DB.PUBLIC.TEST_ASSERTIONS_ALL_TIMES
|
||
|
entity_schema:
|
||
|
- col: col_date
|
||
|
native_type: DATE
|
||
|
# Volume Assertion
|
||
|
- type: volume
|
||
|
entity: urn:li:dataset:(urn:li:dataPlatform:snowflake,test_db.public.test_assertions_all_times,PROD)
|
||
|
metric: row_count
|
||
|
condition:
|
||
|
type: less_than_or_equal_to
|
||
|
value: 1000
|
||
|
schedule:
|
||
|
type: cron
|
||
|
cron: 0 * * * *
|
||
|
meta:
|
||
|
entity_qualified_name: TEST_DB.PUBLIC.TEST_ASSERTIONS_ALL_TIMES
|
||
|
entity_schema:
|
||
|
- col: col_date
|
||
|
native_type: DATE
|
||
|
# Field Metric Assertion
|
||
|
- type: field
|
||
|
entity: urn:li:dataset:(urn:li:dataPlatform:snowflake,test_db.public.test_assertions_all_times,PROD)
|
||
|
field: col_date
|
||
|
metric: null_count
|
||
|
condition:
|
||
|
type: equal_to
|
||
|
value: 0
|
||
|
schedule:
|
||
|
type: cron
|
||
|
cron: 0 * * * *
|
||
|
meta:
|
||
|
entity_qualified_name: TEST_DB.PUBLIC.TEST_ASSERTIONS_ALL_TIMES
|
||
|
entity_schema:
|
||
|
- col: col_date
|
||
|
native_type: DATE
|
||
|
# Field Value Assertion
|
||
|
- type: field
|
||
|
entity: urn:li:dataset:(urn:li:dataPlatform:snowflake,test_db.public.purchase_event,PROD)
|
||
|
field: quantity
|
||
|
condition:
|
||
|
type: between
|
||
|
min: 0
|
||
|
max: 10
|
||
|
schedule:
|
||
|
type: on_table_change
|
||
|
meta:
|
||
|
entity_qualified_name: TEST_DB.PUBLIC.PURCHASE_EVENT
|
||
|
entity_schema:
|
||
|
- col: quantity
|
||
|
native_type: FLOAT
|
||
|
# Custom SQL Metric Assertion
|
||
|
- type: sql
|
||
|
entity: urn:li:dataset:(urn:li:dataPlatform:snowflake,test_db.public.purchase_event,PROD)
|
||
|
statement: select mode(quantity) from test_db.public.purchase_event
|
||
|
condition:
|
||
|
type: equal_to
|
||
|
value: 5
|
||
|
schedule:
|
||
|
type: on_table_change
|
||
|
meta:
|
||
|
entity_qualified_name: TEST_DB.PUBLIC.PURCHASE_EVENT
|
||
|
entity_schema:
|
||
|
- col: quantity
|
||
|
native_type: FLOAT
|