Skip to main content

Rill 0.87 - Databricks Connector, Metrics View Rollups, Tag-based Grouping of Dimensions and Measures, and Cloud Editing

· 6 min read
note

⚡ Rill's BI-as-code powers fast dashboards, embedded analytics, and an agent-ready semantic layer — all running on top of the warehouses you already use.

👉 Get Started • Join our Discord

Databricks Connector​

Rill now supports Databricks in two modes. As a live OLAP connector, metrics views and dashboards can be built on top of existing tables with no data copy. As a data source connector, Rill ingests Databricks data into the OLAP engine for modeling and transformation. Both are available from the "Add Data" flow in the UI.

Metrics View Rollups and Intelligent Query Routing​

Rollups let a metrics view be backed by one or more pre-aggregated tables in addition to the base table. When a query's time grain, dimensions, measures, time range, and filters all match a rollup, Rill transparently rewrites the query to read from the smaller rollup table for faster results, falling back to the base table otherwise. This release adds support for static data ranges, rollup priorities, and comparison queries against rollups.

Required Filters​

You can now mark a dashboard filter as required using the new * toggle next to the pin button in the dimension and measure filter dropdowns.

Tags for Dimensions and Measures​

Dimensions and measures can be annotated with tags in the metrics view. The dimension and measure dropdowns support tag-based filtering to narrow a long list to a relevant group, and tags are carried through to pivot tables. This makes large metrics views considerably easier to navigate.

Cloud Editing (Beta)​

Projects can now be edited directly in Rill Cloud without leaving the browser. An edit session provisions a dedicated dev deployment on a branch where you can make changes to project files, preview the results live, and then Publish or Merge to production through the UI. Cloud Editing ships in this release as a beta behind the cloud_editing feature flag.

Bug Fixes and Improvements​

Explore / Dashboards​

  • Introduced a redesigned Filter Bar component
  • Added configurable pivot totals for Explore and Canvas
  • Restored tooltip and shift-click copy on nested pivot row dimension cells
  • Fixed dimension description tooltip legibility
  • Fixed pivot row dimension width reset
  • Fixed visual explore editing dropping pivot columns on refresh
  • Improved handling of pivot export failures
  • Fixed nav tab underline stale position after sibling tabs mount
  • Fixed user avatar flickering on scroll in the Rill Cloud user list
  • Simplified the table toolbar

Charts​

  • Added data labels to donut charts
  • Added an "Other" bucket and percent-of-total tooltip for circular charts
  • Added a percentMode config and improved percentage formatting for funnel charts
  • Added screenshot (PNG) capture for measure charts
  • Fixed PNG export not supporting different chart types
  • Defaulted new donut charts to summable measures

Canvas​

  • Added pivot click-to-filter in Canvas
  • Added backend validation for all canvas component types
  • Fixed canvas pivot rejecting time-grain row and column dimensions
  • Fixed canvas editor applying property edits to the wrong component
  • Fixed canvas chat context loading forever
  • Fixed canvas parse error missing from the editor preview
  • Fixed hourly canvas chart date labels
  • Fixed transient canvas query errors when adding new components
  • Fixed Canvas dashboards not respecting the custom time range setting
  • Fixed a race reading canvas YAML after async work in saveDefaultFilters

Metrics Views​

  • Allowed querying metrics resolvers with the ReadMetrics permission
  • Added validation to reject comparison queries with no base time range
  • Fixed handling of alert explore names containing spaces, hyphens, and other characters
  • Fixed metrics views on distributed tables
  • Refined the Metrics View modal flows
  • Added metrics view query result caching for live connectors

AI / LLM​

  • Improved AI timeout handling and error messages
  • Added on-brand theme guidance to the theme AI skill
  • Fixed tool call errors displaying the full message
  • Created the working file immediately when sending an AI prompt
  • Fixed AI chat sidebar rendering and hydration in the cloud editor
  • Showed the connector icon at the bottom of the collapsed AI chat sidebar
  • Added glob pattern support to the list_bucket_objects tool
  • Indexed AI sessions on session_id and deleted expired sessions asynchronously in batches

Connectors​

  • Added Databricks as a source connector in the UI
  • Implemented the OLAP interface for the Databricks driver
  • Added a raw type to the runtime type system
  • Handled ClickHouse "access denied" errors gracefully while estimating size
  • Fixed direct file path imports not working
  • Fixed public connector model import failure leading to a dead back button
  • Fixed file upload error not surfacing in the form

Rill Developer​

  • Restored interactive prompts in the devtool seed command
  • Allowed rill devtool to run inside a git worktree
  • Documented reserved rill.* env keys in rill.yaml
  • Fixed env file settings icon not showing for all variations
  • Fixed inaccessible env settings on unpublished projects

Cloud​

  • Added hibernation for idle dev deployments, preserving disks for 30 days
  • Made stopped deployment retention configurable and lowered the dev TTL
  • Added a project-level disk size override and prod/dev slot edit flags to rill project edit
  • Allowed editing dev-ttl-seconds via rill project edit
  • Increased the SQLite backup max size to 5 GB
  • Added "Manage in Stripe" for enterprise customers
  • Fixed the unhibernate project CTA getting stuck in a loading state
  • Guarded project and org admin routes against direct URL access
  • Fixed billing banners showing up on welcome pages
  • Added an org-level setting for billing-related banners

Embedding​

  • Persisted AI conversations in embeds via external_user_id
  • Refactored embedding docs and links to use the admin role for service tokens

Infrastructure​

  • Refactored the SSE client with tighter boundaries and a new lifecycle, then migrated all consumers and dropped the singleton
  • Consolidated runtime JWT issuance
  • Audited and standardized server error codes
  • Disallowed SVG asset uploads to prevent stored XSS
  • Hardened redirect handling against malicious hosts
  • Removed go-git from the file and admin drivers in favor of runtime git APIs
  • Updated dependencies to patch vulnerabilities