Testing config to allow a return of data

[edwrand]

In DBT Cloud I have written a custom test to compare a dimension and fact table to see if there are gapped records. That test looks like this:

`
-- test for gapped records in dim_loans
{{ config(
severity='warn'
) }}

SELECT COUNT(*)
FROM {{ ref('fact_loan_statistics') }}
WHERE loan_key NOT IN (SELECT loan_key FROM {{ ref('dim_loans') }})
`

Within the config block I wish I was able to modify this test so that the actual numerical count of gapped records is returned in the test error message in the console. Said another way, I want this test to return the COUNT() value to the WARN message in the console.

[edwrand]

Adding to this idea. When I run the test above, I get a WARNing messgae, but I am not able to see if this WARN occured from 1 gapped record or 100, so it is not super useful on a granular level.

[edwrand]

I found fail_calc which I believe achieves this. Closing