3 ms·
As an FYI using a tool like DBT solves this problem. As someone who was not a data engineer I was not familiar, there were tools like this
by enepture 4y ago
As an FYI using a tool like DBT solves this problem. As someone who was not a data engineer I was not familiar, there were tools like this
- cpursley 4y agoI have this problem. What is DBT?
- banashark 4y agoI believe this: https://docs.getdbt.com/docs/introduction https://docs.getdbt.com/docs/introduction
- teej 4y agodbt is great, but I'm not sure it's appropriate to manage objects in a production transactional database. It's designed for analytical, columnar databases.
- PaulMest 4y agoIn case you're not familiar with DBT, it helps with the "transform" in ELT https://docs.getdbt.com/docs/introduction https://docs.getdbt.com/docs/introduction.
- WesleyJohnson 4y agoThank you for this. I had no idea this existed either and it may solve some points for us on MySQL where we've really been yearning for materialized views... which I'm now reading my be a foot gun.