✨ PushMetrics v0.2 - Release Notes

OK - this release is a major milestone in the young history of pushmetrics.io - with this release come three major new features that bring notebooks to a completely new level:

• Charts
• Parameters
• Commenting

📊 Charts

Without visualizations it's hard to tell a compelling story. Therefore, charts were definitely a must-have for PushMetrics 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!

⛩ Parameters

There will be much to be said about all the things you can do with Jinja parameters in PushMetrics 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.

3) Macros

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.

💬 Commenting

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!