The problem I’m having
Jinja function this
with dbt_expectations.expect_table_row_count_to_equal_other_table
on Source does not compile correctly.
Did I miss anything from the setup?
Some example code or error messages
Encountered SQL compilation error, this
compiled to:
raw.jaffle_shop.dbt_expectations_source_expect_123xxx
version: 2
sources:
- name: jaffle_shop
database: raw
schema: jaffle_shop
tables:
- name: orders
data_tests:
- dbt_expectations.expect_table_row_count_to_equal_other_table:
row_condition: "order_date = (select max(order_date) from {{ this }})"
group_by: [order_date]
compare_model: "{{ source('jaffle_shop', 'orders').replace_path(database='new_raw', schema='new_jaffle_shop') }}"
compare_row_condition: "order_date = (select max(order_date) from {{ this }})"
compare_group_by: [order_date]