dbt: running unit test and data test
dbt data test is used to test validity of the data during the Transform and load stage and that can be easily setup using the followings example Please note: The model is your file name which is " snowflake_sample_data_store_sales ". Remember dbt always use the filename as model name. Data test models : - name : snowflake_sample_data_store_sales description : List of store sales records with basic cleaning and transformation applied. columns : - name : SS_ITEM_SK description : The unique key for each location. data_tests : - not_null if you run dbt test now, you will get the following output here: Unit test We also have unit test in dbt - that allow us to run unit test against our data. This is useful to ensure our sql used for our TL is working as expected. You need to ensure the model name matches your filenam...