#17 Write Custom tests for models in dbt project  

Hello Mam, This is not called as custom test case in dbt. This is singular test case , Custom test case is one which either we can create a macro or we write in folder tests/generic/Custom_test_name. below is the way we can write a Custom test {% test check_min_night_more_than_1k(model, column_name) %} select * from {{ model }} where {{ column_name }} > 1200 {% endtest %} then call this test in your >yml file same as like Unique and not null test case like below. - name: dim_listings_cleansed columns: - name: listing_id tests: - unique - not_null - name: minimum_nights tests: - check_min_night_more_than_1k Thanks. and also I like your videos ,keep going.