Rill Metrics SQL
Rill Metrics SQL turns data warehouse metrics into governed dashboards, partner embeds, and context for AI agents.
What Rill Metrics SQL is
Rill Metrics SQL turns data warehouse metrics into governed dashboards, partner embeds, and context for AI agents. Its Metrics SQL feature lets users query a metrics view as a table, using its defined dimensions and measures without adding aggregation logic to each query. Sources, models, metrics, and dashboards are specified in SQL and YAML and can be version-controlled in Git. Dashboards offer 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 themes and partner data scoping. Documented connectors include 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. Rill also exposes governed metrics through an MCP server for AI agents. Starter is $20 a month and Growth is $30 a month; Enterprise pricing is custom.
Good
- Metrics views can be queried without query-level aggregation logic.
- Definitions can be version-controlled in Git.
- Dashboards include alerts and scheduled reports.
- Metrics SQL APIs inherit metrics-view security policies.
- Offers iframe, JWT-link, and headless API embedding.
Watch out
- Starter compute is billed separately.
- Starter embeds are previews only.
- Growth includes embedded analytics for up to 100 active seats.
- Enterprise pricing is custom.
Who it suits
Rill suits teams that define warehouse metrics in SQL and YAML and need governed dashboards or embedded analytics. Its MCP server and integrations may also suit teams connecting metrics to AI agents.
Verdict
Rill brings metrics definitions, dashboarding, security, and embedding into one data-warehouse workflow. Compare the seat, project, embedding, and separately billed compute limits with your needs.
Plans and prices
From Rill Metrics SQL's own pricing page, checked 5 Oct 2026.
| Plan | Price | What it gives you |
|---|---|---|
| Starter | $20 a month | Up to 20 seats · Up to 3 projects · Embedded analytics previews only · Compute billed separately · $20 / seat / month |
| Growth | $30 a month | Up to 100 seats · Up to 10 projects · Embedded analytics $500 / month, up to 100 active embedded seats · Compute billed separately · $30 / seat / month |
| Enterprise | Priced on request | Unlimited seats · Unlimited projects · Dedicated infrastructure · Custom quotas · Custom pricing · Annual platform license with negotiated capacity |
The facts
Each one read from Rill Metrics SQL's own pages, with the date it was checked.
What it does
- 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.checked 5 Oct 2026
- AI
- Rill exposes its governed metrics layer through an MCP server for use by Claude, ChatGPT, and other agents.checked 5 Oct 2026
- Compliance
- The product page states that Rill has SOC 2 Type 2.checked 5 Oct 2026
- Dashboards
- Dashboards support pivot tables, time comparisons, drill-downs, scheduled reports, and threshold alerts.checked 5 Oct 2026
- Definitions
- Sources, models, metrics, and dashboards are defined in SQL and YAML and can be version-controlled in Git.checked 5 Oct 2026
- Embedding
- Rill supports iframe embeds, JWT-secured links, and a headless API, with white-label theming and partner data scoping.checked 5 Oct 2026
- Integrations
- Documented connectors include ClickHouse, BigQuery, Databricks, Redshift, Snowflake, PostgreSQL, MySQL, S3, GCS, Azure Blob Storage, Claude, OpenAI, Gemini, and Slack.checked 5 Oct 2026
- 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.checked 5 Oct 2026
- Product
- Rill turns SQL into governed dashboards, partner-ready embeds, and agent-ready context on existing data warehouses.checked 5 Oct 2026
- 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.checked 5 Oct 2026
Money
- Free access
- The pricing page offers a free start and says all plans include $250 usage credit; it does not state a trial duration.checked 5 Oct 2026
Where it runs
- Platform availability
- Rill Developer installs on macOS and Linux; on Windows it runs through WSL, with Ubuntu 22.04 LTS verified by Rill.checked 5 Oct 2026
Alternatives to Rill Metrics SQL
- 1
MetricFlow
Free planOpen sourceWebAPILinuxmacOS8.1From $100 a month - 2
Cube
Free planOpen sourceWebAPILinuxSelf-hosted7.9From $40 a month - 3
dbt Semantic Layer
Free planWebAPIExtension7.5From $100 a month - 4
Starburst Enterprise Context Layer
Free planWebAPISelf-hosted7.5$0.50 usage-based - 5
Sema
Free planWebAPISelf-hosted7.3From $49 a month - 6
Looker
AndroidiOSWebAPI6.9