Skip to content
Advertisement

Tag: testing

What is the value of schema tests in dbt?

When would you want to use a dbt schema tests (unique, not_null, accepted_values, & relationships) when you could instead use SQL schema constraints? For example, here are some SQL schema constraints that could replace each of the dbt schema tests: unique: UNIQUE constraint not_null: NOT NULL constraint accepted_values: FOREIGN KEY constraint to a lookup table relationships: FOREIGN KEY constraint to

Get the all unique permutation and combinations of ‘where clause conditions’ for my table in SQL Server

I would like to see all possible unique scenarios of my data in a table. I can give the Input like Operators=[<,>,=,……] Operands=[mode, StartDate,EndDate,…..] I am expecting the result like 0 and 1/1/2018<1/12/2018 0 and 1/1/2020=1/1/2020 1 and 1/1/2018>5/5/2015 1 and 3/8/2015<1/12/2019 1 and 19/11/1992=19/11/1992 these are my unique patterns in my data. So is there any query or java

Advertisement