Removing Jinja Comments from Compiled SQL

Show and Tell
1

Putting this here. To prevent DBT from materializing comments, wrap them in Jinja comments.

{# I can write stuff here all day, and it won't show up in compiled sql #}

---- however this stuff will be all over the compiled code
2

I’m a fan of putting block sql comments within block jinja comments, so syntax highlighters don’t freak out:

{# /* super sneaky comments */ #}
2 Likes
3

I do this too @michael.dunn! I think it’s a really nice little trick