| https://twitter.com/pdrmnvd | |
| Substack | https://pedram.substack.com |
| https://twitter.com/pdrmnvd | |
| Substack | https://pedram.substack.com |
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
Hex has first-class SQL support via SQL cells, each of which is a fully fledged query IDE complete with autocompletion, caching, a Data browser, and more. Projects can have an unlimited number of SQL cells interleaved with Text, Code, Chart, or Input cells, creating an extremely flexible querying environment.
dbt-duckdb 1.4.0 is up on PyPI with hassle-free support for #DuckDB 0.7.0 and the new attachable databases feature! Checkout the updated README sections and let me know if you run into any problems!
https://github.com/jwills/dbt-duckdb#attaching-additional-databases
๐ 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