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
How we set up our computers for working on dbt projects Archive	20	99898	May 5, 2022
Here is a way to write dbt docs as SQL comment Show and Tell dbt-docs	1	7818	September 27, 2020
Setting up an IDE to understand jinja commands and macros Archive	1	4313	March 5, 2020
Setting up VSCode to use with the dbt CLI Show and Tell tools , cli , vs-code	12	88331	December 11, 2023
DBT Linter that parses Jinja instead of compiled SQL Archive	1	3528	July 19, 2022

A dbt highlighter for Atom! ⚛️

Related topics