I am trying to do unit testing in dbt core. Is there any option to drop the schema completely at the being of test? I tried to add "drop schema " in pre-hook, but it is not working as expected.
Can you perhaps explain how it is working differently to what you expected? Also, have you considered a run-operation?
Note: @Johann De Wet originally posted this reply in Slack. It might not have transferred perfectly.
Old data in the unit testing schema is retained. And when i include post-hook operation in yml file, it tries to drop the schema after running every model.