I’ve released dbt-factory which enable you to write re-usable sql code blocks and compile to a dbt project through a yaml configuration
Benefits
-
Construct pipeline without knowing SQL
-
Construct pipelines without learning dbt
-
Avoid duplicative code
-
Easier automation of pipeline creation, so your code can interact with yaml instead of sql (advanced users)
Let me know if anyone has any thoughts 