Hello All,
I am new to dbt and would help from your inputs on the following problem statement. We have our final fact table on Data mart on Snowflake that is being refreshed incrementally using Delete + Insert strategy. We have a few flags that need to be updated based on the delta that got inserted during each run. We have decided to use Post hook utility with a couple of update statements encapsulated. What are the best practices around using hooks and what does the dbt community think of using the Pre/Post hooks. We tried other options without success and Post-hook is working fine. Please share your inputs on this topic as to how would Architecture review team feel about using Pre/Post hooks. Thanks in advance!