Bug in anomaly result query

[oleg-savko]

in anomaly result query (which is in UI), table is None (used clickhouse)

select * from (None) results
      where
        anomaly_score is not null and
        upper(full_table_name) = upper(cast('...' as String)) and
        metric_name = cast('null_percent' as String)
          and upper(column_name) = upper(cast('sent_amount' as String))

seems problem here where {{ sql }} not defiend

dbt-data-reliability/macros/edr/data_monitoring/anomaly_detection/store_anomaly_test_results.sql

Lines 33 to 42 in 1f753cb

	{%- set test_results_query -%}
	select * from ({{ sql }}) results
	where
	anomaly_score is not null and
	upper(full_table_name) = upper({{ elementary.const_as_string(full_table_name) }}) and
	metric_name = {{ elementary.const_as_string(metric_name) }}
	{%- if column_name %}
	and upper(column_name) = upper({{ elementary.const_as_string(column_name) }})
	{%- endif %}
	{%- endset -%}