A dbt highlighter for Atom! ⚛️

claire · November 19, 2018, 5:50pm

We’ve built a basic dbt-flavored highlighter for atom!

It highlights jinja within sql, yaml, and markdown files, and it also includes a number of standard and dbt-specific jinja snippets.

atom-dbt-demo

UPDATE: It’s now a published Atom package, with even MOAR snippets! You can install it the way you would any other package – just go to Packages > Settings View > Install Packages and search for atom-dbt¹.

Check out the source code here – pull requests welcome!

¹If you had already installed the package by cloning and using apm link, first run apm uninstall atom-dbt from your command line before installing the published package

tristan · November 19, 2018, 5:52pm

I’m using this already, started this morning! Big fan of the syntax highlighting

ted.conbeer · November 19, 2018, 6:34pm

@claire Haven’t even installed it yet, and already SO excited

jesse · November 20, 2018, 3:34pm

Ported to Vim!

gist.github.com

https://gist.github.com/jgillies/8a7e83a43860691dd2532345ab4b5af7

dbt.snippets

" adapted from https://github.com/fishtown-analytics/atom-dbt/blob/master/snippets/atom-jinja2.cson

snippet config "dbt config block" b
\{\{
    config(
        materialized = "$1",
        sort = "$2",
        dist = "$3"
	)
\}\}

This file has been truncated. show original

jesse · November 20, 2018, 3:39pm

I forgot that I had also created this snippet for dbt docs.

gist.github.com

https://gist.github.com/jgillies/624158077a7736abcf0059d8cc787aa4#file-yaml-snippets

yaml.snippets

snippet cols "Creates dbt column documentation" b
- name: $1
    description: $2
    ${3:tests:}
endsnippet

Topic		Replies	Views
DBT Linter that parses Jinja instead of compiled SQL Archive	1	3143	July 19, 2022
Enabling Jinja syntax support in SQL files in PyCharm Show and Tell tools , developer-ergonomics	7	17611	November 23, 2023
Introducing sqlfmt, an auto-formatter for dbt SQL Show and Tell sqlfmt	22	19531	April 12, 2023
Setting up an IDE to understand jinja commands and macros Archive	1	3951	March 5, 2020
errors with dbt run after setting up linters Help	0	80	July 8, 2024

A dbt highlighter for Atom! ⚛️

Related topics