Skip to content
SPECIFICTION
Get listed

Rill Metrics SQL

rilldata.com

From $20/mo Free trial WebWindowsmacOSLinuxAPISelf-hosted
Visit rilldata.com
Spec score 7.9 #15 of 28 in Semantic Layer Software

What it is

Rill Metrics SQL turns data warehouse metrics into governed dashboards, partner embeds, and context for AI agents. Metrics SQL lets users query a metrics view as a table, using its defined dimensions and measures without putting aggregation logic into each query. Sources, models, metrics, and dashboards are defined in SQL and YAML and can be version-controlled in Git. Dashboards support pivot tables, time comparisons, drill-downs, scheduled reports, and threshold alerts. Embedding options include iframes, JWT-secured links, and a headless API, with white-label theming and partner data scoping. Rill documents connectors for ClickHouse, BigQuery, Databricks, Redshift, Snowflake, PostgreSQL, MySQL, S3, GCS, Azure Blob Storage, Claude, OpenAI, Gemini, and Slack. Role-based access controls and YAML policies support row- and column-level security; Metrics SQL APIs inherit metrics-view policies. An MCP server exposes governed metrics to AI agents. Starter is $20 per seat per month and Growth is $30 per seat per month; Enterprise pricing is custom.

Spec sheet

Product
Rill turns SQL into governed dashboards, partner-ready embeds, and agent-ready context on existing data warehouses.Read 5 Oct 2026 · rilldata.com
Integrations
Documented connectors include ClickHouse, BigQuery, Databricks, Redshift, Snowflake, PostgreSQL, MySQL, S3, GCS, Azure Blob Storage, Claude, OpenAI, Gemini, and Slack.Read 5 Oct 2026 · docs.rilldata.com
Compliance
The product page states that Rill has SOC 2 Type 2.Read 5 Oct 2026 · rilldata.com
Support
Starter lists a 1 business day response time, Growth lists a 6 hour response time with 24/7/365 support, and Enterprise lists a 1 hour response time, SLA, and dedicated account manager.Read 5 Oct 2026 · rilldata.com
Access controls
Rill offers role-based access controls and YAML-authored row- and column-level security policies; Metrics SQL APIs inherit metrics-view security policies.Read 5 Oct 2026 · rilldata.com
AI
Rill exposes its governed metrics layer through an MCP server for use by Claude, ChatGPT, and other agents.Read 5 Oct 2026 · rilldata.com
Dashboards
Dashboards support pivot tables, time comparisons, drill-downs, scheduled reports, and threshold alerts.Read 5 Oct 2026 · rilldata.com
Definitions
Sources, models, metrics, and dashboards are defined in SQL and YAML and can be version-controlled in Git.Read 5 Oct 2026 · rilldata.com
Embedding
Rill supports iframe embeds, JWT-secured links, and a headless API, with white-label theming and partner data scoping.Read 5 Oct 2026 · rilldata.com
Free access
The pricing page offers a free start and says all plans include $250 usage credit; it does not state a trial duration.Read 5 Oct 2026 · rilldata.com
Metrics SQL
Metrics SQL lets users query a metrics view as a table using defined dimensions and measures without writing aggregation logic in the query.Read 5 Oct 2026 · rilldata.com
Platform availability
Rill Developer installs on macOS and Linux; on Windows it runs through WSL, with Ubuntu 22.04 LTS verified by Rill.Read 5 Oct 2026 · docs.rilldata.com

Plans and prices

Starter $20 a month $20 / seat / month Up to 20 seats · Up to 3 projects · Embedded analytics previews only · Compute billed separately Read 5 Oct 2026 · rilldata.com
Growth $30 a month $30 / seat / month Up to 100 seats · Up to 10 projects · Embedded analytics $500 / month, up to 100 active embedded seats · Compute billed separately Read 5 Oct 2026 · rilldata.com
Enterprise Priced on request Custom pricing · Annual platform license with negotiated capacity Unlimited seats · Unlimited projects · Dedicated infrastructure · Custom quotas Read 5 Oct 2026 · rilldata.com

Every Rill Metrics SQL plan and price →

Strong points and limits

Strong points

  • Metrics SQL queries defined dimensions and measures.
  • Dashboards include drill-downs and threshold alerts.
  • Embeds support partner data scoping.
  • YAML policies support row- and column-level security.
  • All plans include $250 usage credit.

Limits

  • Starter compute is billed separately.
  • Growth compute is billed separately.
  • Starter embeds are previews only.
  • Enterprise pricing is custom.

Who it suits

Rill suits teams building governed analytics from warehouse data, including teams embedding dashboards for partners or exposing metrics to AI agents. It is also aimed at teams that define data assets in SQL and YAML and version them in Git.

Verdict

Rill combines a governed metrics layer with dashboards, embedding, and agent access. Review seat, project, embedding, and compute limits alongside the listed plan prices.

Where Specifiction places it

Alternatives to Rill Metrics SQLAll alternatives →