Use Google Sheets to automate your data pipeline development:
- ETL Generator
- DDL Generator
- DML Generator
- Documentation Generator
- Code Generator
This isn’t the first time I’ve talked about a code generator or SQL Generation on this blog, but it’s worth discussing again because I wanted to talk about a recent project where I upped the ante on not just generating SQL, but generating the DDL & DML to support an entire ETL pipeline — all while self-documenting everything!
Continue reading →Throughout the project I was able to quickly test different indexing strategies without writing a single line of code.