One of my favourite underrated Hex features has got to be query mode.

Instead of returning a dataframe, Hex builds a query you can iteratively work on. As if every CTE had its own table output. Really magical.

https://learn.hex.tech/docs/logic-cell-types/sql-cells/overview#query-mode

🚀 Docs are written, CI checks passed. 0.0.1 is released! https://github.com/PedramNavid/dbtpal/releases/tag/v0.0.1

Features:
- Run / test model, project, or selectors.
- Async jobs with pop-up outputs
- Jinja-aware SQL syntax highlighting
- Protects compiled files
- Fuzzy Find go-to-file

Fun one: added a telescope extension for fuzzy finding any model and opening it quickly.

One issue, though is `dbt ls` doesn't differentiate between your models and imported packaged ones, so some work still to be done. (Please don't make me parse yaml)

#dbt #neovim #nvim #lua #datadon

In India for a wedding, some photos from Delhi, where we spent a few days before we head to Jaipur and Agra.

#travel #photography #travelphotography #india

This was really fun, diving into vim syntax internals to create a syntax definition for dbt-flavored jinja, covering macros, functions, statements, and some common dbt identifiers.

Using a hot-key below to switch from built-in sql highlighting and my dbt jinja plugin.

#vim #dbt #jinja