print_data_test_failures.sql

{% set n = 100 %}
{%- call statement('test_result', fetch_result=True) -%}

    -- data test

    select 1 as id, 'Drew' as name
    union all
    select 2 as id, 'Connor' as name

    limit {{ n }}

{%- endcall -%}

{%- set res = load_result('test_result')['table'] -%}

{% if (res | length) > 0 %}
    {{ log("\nFound " ~ (res | length) ~ " failing records:", info=True) }}
    {% set _ =  res.print_table() %}
    {{ log("\n", info=True) }}

    {% for row in res %}
        select 'fail' as status {% if not loop.last %} union all {% endif %}
    {% endfor %}

{% else %}

select 'pass' as status limit 0

{% endif %}