Skip to main content

Rill 0.67 – Navigate to Explore in Canvas, Edit Alerts & Reports, and Add Model Tests

· 3 min read
note

⚡ Rill Developer is a tool that makes it effortless to transform your datasets with SQL and create fast, exploratory dashboards. Rill Cloud then enables shared collaboration at scale.

To try out Rill Developer, check out these instructions and join us on Discord to meet the team behind the product as well as other users. Once you have a project set up in Rill Developer, you can deploy the project and collaborate with others by logging into Rill Cloud!

release-0 67

You can now navigate directly from Canvas widgets to an Explore dashboard for deeper analysis. This is especially useful for KPI-style dashboards, allowing users to seamlessly carry over filters and context from Canvas to Explore.

Edit Alerts and Reports

It’s now possible to modify the underlying filters for Alerts and Reports. This means you can easily update existing ones without needing to delete and recreate them from scratch.

Model Tests

You can now write SQL tests that assert the correctness of your model’s data during reconciliation. This ensures your models pass data quality checks and that your dashboards reflect accurate information.

# model.yaml
type: model
sql: SELECT * FROM range(5)

tests:
# Test that all values are in a valid range
- name: Valid Range
assert: range >= 0 AND range <= 4

# Test that all values are in a valid range (SQL)
- name: Valid Range SQL
sql: SELECT * FROM model WHERE range < 0 OR range > 4

# Test that row count is exactly 5
- name: Exact Row Count
sql: SELECT 'Wrong row count' as error WHERE (SELECT COUNT(*) FROM model) != 5

Bug Fixes and Misc

  • Added the ability to lock the cell value inspector with "L" and scroll through values.
  • Added support for individual credentials on Snowflake.
  • Added the ability to perform 'full' or 'incremental' refreshes in Rill Cloud.
  • Added support for creating DuckDB secrets for object store connections.
  • Model validation now applies to both non-incremental and incremental models.
  • Deprecated boot_queries in favor of init_sql, which runs at database initialization.
  • Fixed a bug in the Rill Cloud Usergroup UI where a removed user was still shown as selected.
  • Improved UX for draggable dimensions and measures, ensuring updates in the dashboard occur correctly with no stale items.
  • Improved UX when sorting by project refresh status on the Rill Cloud project status page.
  • Optimized Pinot time filters.
  • Improved CLI project partitions content to show the most recent executions first (reverse order).