Summary
Congratulations, you made it to the end of this book!
In this chapter, we presented some more advanced patterns for ingesting data into Snowflake and multiple extensions of the save_history
macro for dealing with different use cases, from detecting deleted rows to ingesting multiple versions at once to managing PII in our history tables.
As the author, first and foremost, I hope that I have passed on some of my passion for software engineering and the pleasure to put together a well-architected, simple-to-understand project that makes it possible to onboard new colleagues and maintain and evolve the functionalities without losing any sleep.
One of the key goals of the team working on this book was to discuss data engineering and data architecture while presenting how dbt works and how it can be used to solve the common problems that we all face when building a data platform.
After decades of dealing with data, I have my opinionated way of doing things, and this...