3 ms·
I love mviews since discovering them! So easy to split complex queries into multiple smaller ones, which are then queried sequentially through mviews.
by Helmut10001 4y ago
I love mviews since discovering them! So easy to split complex queries into multiple smaller ones, which are then queried sequentially through mviews.
- epgui 4y agoSounds just like dbt, but less organized and without jinja templates.
- adammarples 4y agoPeople who don't use dbt usually have a half baked implementation they wrote themselves in python
- Helmut10001 4y agoI write my SQL queries in Jupyter Lab, mixed in Python code and f-strings, which is enough of a template engine to my needs atm. I can also directly visualize stuff with pandas (etc.) species: str = 'acer' structure: str = 'trees.table' query = f""" SELECT * FROM {structure} WHERE species = {species} """