Skip to main content

Rill 0.32 - Level Up Your Data Exploration ๐Ÿ“ˆ

ยท 2 min read
note

โšก Rill Developer is a tool that makes it effortless to transform your datasets with SQL and create fast, exploratory dashboards.

To try out Rill Developer, check out these instructions and let us know over on Discord if you encounter any problems or have ideas about how to improve Rill Developer!

release-0 32

๐Ÿฆ† DuckSQL comes to sources with inline editing!โ€‹

DuckSQL support allows you to do more data wrangling during initial load!

With inline editing, you can now specify custom schemas, filters, and aggregations to shape your data before analysis.

๐Ÿ” Introducing...Scrub-to-Zoom!โ€‹

Just click and drag across any part of a timeseries chart to instantly select a subset of data. Dynamically zoom in on the exact points of the timeseries that matter to you and dig in further. It is like a magic magnifying glass to investigate spikes, dips, anomalies or any area of interest. Go ahead - scrub your way to insights!

๐Ÿ•’ Friendlier Interval Formattingโ€‹

Intervals can now be formatted in friendly units like years, months, and days. This makes it way easier to see the time scale at a glance. To format a metric as a pretty time interval, set format-preset: interval_ms in your dashboard spec. The formatter assumes your interval is in milliseconds. If using a different unit, use a multiplier in your SQL to convert metric to milliseconds.

โšก Lightning Fast Data Exports and Parquet Supportโ€‹

Export big data at warp speed! Rill now uses DuckDBโ€™s COPY TO statement to execute CSV and Parquet data exports. By pushing exports into the database, we reduce serialization overhead, leading to much improved performance. Exporting 200 million rows now takes seconds instead of minutes.

More Improvements to Exploreโ€‹

We packed even more enhancements into this release:

  • Easy Dashboard Discovery - Finding your dashboards on Rill Cloud just got way simpler. The new homepage highlights your dashboards front and center.

  • Timezone Flexibility - Want to disable timezone selection for a specific use-case? No prob! Just omit available_timezones in your dashboard spec.

  • Seamless Data Refresh - Say goodbye to dashboard downtime during data refresh. Rill Cloud now updates your data seamlessly behind-the-scenes so your dashboards are always available.

With an array of upgrades both big and small, Rill 0.32 takes your data exploration to the next level. Try it out and let us know what you think!