vscode-dbt README

Provides snippets for dbt-flavoured SQL in VSCode

Features

for loops, conditionals, blocks, variable settings etc. See source for a full list

ref, source, log, config etc. See source for a full list.

Syntax highlighting, and jinja comments {# comment #} formatting is extremely well implemented in the Better Jinja VSCode extemsion. You really should install it as this extension is meant to work for the language jinja-sql which is implemented in this extention
Once you have installed the Better Jinja extension you may want to associate your .sql files with the jinja-sql language that you do not have to select it every time but this is entirely up to you and your use case. For example, you may in some cases not want to write dbt-/jinja-flavoured SQL.
To associate your .sql files with jinja-sql (optional but recommended) language add the following to your settings.json file:

   "files.associations":{
      "*.sql":"jinja-sql",
   }

The package is currently not hosted on the VSCode Extension Marketplace. To install it: