- an established convention for project organization
- a tool to run lots of SQL queries at scale
- a tool to create and update views in the correct graph order to avoid dependency issues (e.g. removing a column from child view that parent still depends on).
- SQL codegen / templating using Jinja
- an ecosystem of packages that provide useful utility macros. E.g. every project eventually needs a calendar. Just look at that SQL statement to generate one. It’s gnarly.
- a test runner on data to ensure quality and contract adherence to avoid breakage upstream.