Dbt
official website: https://www.getdbt.com/
Summary:
- Uses Jinja with SQL to write highly reusable models
- Has multiple materialization approaches
- View
- Table
- Incremental (preferred)
- Ephemeral
- Uses engineering best practices like versioning, documentation and testing