Jinja/DBT SQL Templating in JupyterLab/VSCode

Quickly prototype your SQL templates

SQL itself doesn’t lend itself well to reusability. To achieve reusability SQL is often templated using libraries like Jinja. For example Apache Superset leverages Jinja templating in its Dataset definitions and of course DBT is a tool built entirely around Jinja templates. Jupyterlab-sql-editor natively supports Jinja templating making it possible to prototype jinja-sql templates for Superset and DBT right inside JupyterLab and VSCode.

Create reusable SQL using Jinja templates …

dbt jupyterlab spark sql vscode