You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Hey,
using the tests in dbt is super helpful to figure out if your query works with your data but it can become very heavy to run and it still might not test every possible case for your code.
Property based testing is a method for writing unit tests that doesn't test specific inputs but instead generate random input (could be based on the column types of a table) and makeing sure that a function (or query) fullfills a property (e.g. idempotents or commutativity (incase of incremental queries) etc).
Would love to discuss with people if we could create a package for dbt that could do this!
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
-
Hey,
using the tests in dbt is super helpful to figure out if your query works with your data but it can become very heavy to run and it still might not test every possible case for your code.
Property based testing is a method for writing unit tests that doesn't test specific inputs but instead generate random input (could be based on the column types of a table) and makeing sure that a function (or query) fullfills a property (e.g. idempotents or commutativity (incase of incremental queries) etc).
Would love to discuss with people if we could create a package for dbt that could do this!
Beta Was this translation helpful? Give feedback.
All reactions