OK - this release is a major milestone in the young history of query.me - with this release come three major new features that bring notebooks to a completely new level:
Without visualizations it's hard to tell a compelling story. Therefore, charts were definitely a must-have for Query.me Notebooks. However, we think there are many, many great visualization libraries out there already and we didn't want to reinvent the wheel here. That's why we decided to implement the widely popular and super awesome
plot.ly chart library into our notebooks.
You can now visualize the results of your SQL queries with just a few clicks - but you can also go wild and fine tune the look and feel of your visualizations to craft the perfect viz.
You can even create a chart that plots data from two different queries - even from two different databases!
There will be much to be said about all the things you can do with Jinja parameters in Query.me but this release adds a few really powerful new ideas to notebooks:
1) Parameter Blocks
You can now create parameter blocks to define values via a UI. So you can create reusable queries that can be easily changed without having to touch SQL.
2) Referencing other SQL blocks
You can now reference other SQL blocks - like a spreadsheet cell. The referenced query will be parsed into the second query, allowing you to create modular, DRY code.
You can also create
Macros and use them in your queries. Macros are comparable with functions in regular programming languages. They are useful to put often used idioms into reusable functions to not repeat yourself (“DRY”).
4) Importing Parameter context from other Notebooks
Finally, you can not only use macros, parameter values and query references from the current notebook but you can import the Jinja parameter context from other notebooks, too!
With this you can build a system of reusable, modular SQL blocks and really keep things clean and DRY! For example, you can create a notebook with all your snippets and utility functions and then reuse those in any other notebook across your workspace.
One of many collaboration features we want to add. You can now add threads and comments to any block inside a notebook to have the conversations right next to the context
Apart from that, we added countless small improvements and bug fixes, continuing our quest to build the ultimate query experience!