Rill Metrics SQL
rilldata.com
- Free trial
- Windows
- macOS
- Linux
- Web
- API
- Self-hosted
What Rill Metrics SQL is
Rill Metrics SQL turns existing 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 defined dimensions and measures, without writing aggregation logic in each query. Sources, models, metrics and dashboards are defined in SQL and YAML and can be version-controlled in Git. Dashboards provide pivot tables, time comparisons, drill-downs, scheduled reports and threshold alerts. Embedding supports iframes, JWT-secured links and a headless API, with white-label theming 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 cover row- and column-level security, and Metrics SQL APIs inherit metrics-view policies. An MCP server exposes governed metrics to Claude, ChatGPT and other agents. Starter costs $20 a month per seat; Growth costs $30 a month per seat. Enterprise pricing is custom.
Who it suits
It suits data teams that define metrics in code, build embedded analytics or expose governed warehouse context to AI agents. It supports hybrid deployment across web, API, self-hosted and desktop environments.
Good to know, and what to watch
- Queries governed metrics as tables
- Definitions can be version-controlled in Git
- Supports embedded analytics and partner scoping
- Provides row- and column-level policies
- Exposes metrics through an MCP server
- No free plan is listed
- Compute is billed separately
- Windows use requires WSL
- Enterprise pricing is custom
Plans
Every plan and priceEnterprise
Starter
Growth
30-day trial
The verdict
Rill Metrics SQL connects version-controlled metric definitions with dashboards, embeds, security policies and agent access. Seat limits, separate compute billing and deployment requirements should shape evaluation.
What the maker publishes
- 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. source
- AI
- Rill exposes its governed metrics layer through an MCP server for use by Claude, ChatGPT, and other agents. source
- Compliance
- The product page states that Rill has SOC 2 Type 2. source
- Dashboards
- Dashboards support pivot tables, time comparisons, drill-downs, scheduled reports, and threshold alerts. source
- Definitions
- Sources, models, metrics, and dashboards are defined in SQL and YAML and can be version-controlled in Git. source
- Embedding
- Rill supports iframe embeds, JWT-secured links, and a headless API, with white-label theming and partner data scoping. source
- Free access
- The pricing page offers a free start and says all plans include $250 usage credit; it does not state a trial duration. source
- Integrations
- Documented connectors include ClickHouse, BigQuery, Databricks, Redshift, Snowflake, PostgreSQL, MySQL, S3, GCS, Azure Blob Storage, Claude, OpenAI, Gemini, and Slack. source
- 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. source
- Platform availability
- Rill Developer installs on macOS and Linux; on Windows it runs through WSL, with Ubuntu 22.04 LTS verified by Rill. source
- Product
- Rill turns SQL into governed dashboards, partner-ready embeds, and agent-ready context on existing data warehouses. source
- 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. source
Checked against the maker's pages on 5 Oct 2026.