Skip to content

Instantly share code, notes, and snippets.

@lightle

lightle/data_tests.yml

Created April 24, 2024 04:24
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save lightle/37206fc9e454a54fe722dd916e412659 to your computer and use it in GitHub Desktop.
Save lightle/37206fc9e454a54fe722dd916e412659 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
data_tests.yml
version: 2
models:
- name: last_day_of_month_test
description: "A starter dbt model"
tests:
- dbt_utils.expression_is_true:
expression: "is_last_day_of_month = TRUE"
config:
where: "datecol = '2023-12-31'"
- dbt_utils.expression_is_true:
expression: "is_last_day_of_month = FALSE"
config:
where: "datecol = '2022-12-03'"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment