Throughout this book so far, we have covered topics such as models and snapshots, which primarily make use of mostly straightforward SQL transformations. However, have you ever found yourself writing repetitive SQL code that you wish you could easily use throughout your transformations without needing to rewrite the same code every time? This is where Jinja in conjunction with dbt comes in and adds extensible programmatic capability to your SQL code.

错误:搜索内容不能为空,请输入英文关键词
错误:关键词超出字数限制,请精简
高级检索

Jinja, Macros, and Packages

  • Dustin Dorsey,
  • Cameron Cyr

摘要

Throughout this book so far, we have covered topics such as models and snapshots, which primarily make use of mostly straightforward SQL transformations. However, have you ever found yourself writing repetitive SQL code that you wish you could easily use throughout your transformations without needing to rewrite the same code every time? This is where Jinja in conjunction with dbt comes in and adds extensible programmatic capability to your SQL code.