# great_expectations/checkpoints/orders_checkpoint.ymlname:orders_checkpointconfig_version:1.0class_name:Checkpointrun_name_template:"%Y%m%d-%H%M%S-orders-validation"validations:-batch_request:datasource_name:warehousedata_connector_name:default_inferred_data_connector_namedata_asset_name:ordersdata_connector_query:index:-1# Latest batchexpectation_suite_name:orders_suiteaction_list:-name:store_validation_resultaction:class_name:StoreValidationResultAction-name:store_evaluation_parametersaction:class_name:StoreEvaluationParametersAction-name:update_data_docsaction:class_name:UpdateDataDocsAction# Slack notification on failure-name:send_slack_notificationaction:class_name:SlackNotificationActionslack_webhook:${SLACK_WEBHOOK}notify_on:failurerenderer:module_name:great_expectations.render.renderer.slack_rendererclass_name:SlackRenderer
# Run checkpointimport great_expectations as gx
context = gx.get_context()
result = context.run_checkpoint(checkpoint_name="orders_checkpoint")
ifnot result.success:
failed_expectations = [
r for r in result.run_results.values()
ifnot r.success
]
raise ValueError(f"Data quality check failed: {failed_expectations}")
-- tests/generic/test_row_count_in_range.sql
{% test row_count_in_range(model, min_count, max_count) %}
with row_count as (
selectcount(*) as cnt from {{ model }}
)
select cnt
from row_count
where cnt < {{ min_count }} or cnt > {{ max_count }}
{% endtest %}
-- Usage in schema.yml:-- tests:-- - row_count_in_range:-- min_count: 1000-- max_count: 10000000
-- tests/generic/test_sequential_values.sql
{% test sequential_values(model, column_name, interval=1) %}
with lagged as (
select
{{ column_name }},
lag({{ column_name }}) over (orderby {{ column_name }}) as prev_value
from {{ model }}
)
select*from lagged
where {{ column_name }} - prev_value != {{ interval }}
and prev_value isnot null
{% endtest %}
-- tests/singular/assert_orders_customers_match.sql-- Singular test: specific business rulewith orders_customers as (
selectdistinct customer_id from {{ ref('fct_orders') }}
),
dim_customers as (
select customer_id from {{ ref('dim_customers') }}
),
orphaned_orders as (
select o.customer_id
from orders_customers o
leftjoin dim_customers c using (customer_id)
where c.customer_id isnull
)
select*from orphaned_orders
-- Test passes if this returns 0 rows