Skip to content

Instantly share code, notes, and snippets.

@vvgsrk

vvgsrk/validate_row_count_for_lattest_and_incremental.sql

Created April 28, 2022 12:46
Show Gist options
  • Save vvgsrk/ca8691da7df44ca43a3ac0d93504b0b5 to your computer and use it in GitHub Desktop.
Save vvgsrk/ca8691da7df44ca43a3ac0d93504b0b5 to your computer and use it in GitHub Desktop.
Download ZIP
Validate row count for lattest based on history and incremental models
Raw
validate_row_count_for_lattest_and_incremental.sql
{% test validate_row_count_for_lattest_and_incremental(model, incremental_model) %}
{{ compare_lattest_and_incremental_row_count(model, ref(incremental_model)) }}
WHERE diff_count > 0
{% endtest %}
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment