Unable to create a custom test to find if a column has a list of values
Trying to create a custom test to find if a column has a list of values and return all the columns of that row.
The code works when i hard code the list of values. But in this case I want the list of values to be passed at run time so that I can reuse this test.
Some example code or error messages
{% test value_list(model,column_name,list_values ) %}
with value_list_validation as(
Select *
from {{model}}
where {{column_name}} not in ({{list_values}})
)
Select * from value_list_validation
limit 10
{% endtest %}