Rill Metrics SQL

What Rill Metrics SQL is

Rill Metrics SQL turns data in existing warehouses into governed dashboards, embeddable analytics, and context for AI agents. Its Metrics SQL feature lets people query a metrics view like a table, using defined dimensions and measures without adding aggregation logic to each query. Sources, models, metrics, and dashboards are described in SQL and YAML, and those definitions can be version-controlled in Git. Dashboards include pivot tables, time comparisons, drill-downs, scheduled reports, and threshold alerts. Rill supports iframe embeds, JWT-secured links, and a headless API, with white-label theming and partner data scoping. Documented integrations span databases, warehouses, cloud storage, AI services, and Slack. Role-based controls and YAML policies cover row- and column-level access, and Metrics SQL APIs inherit metrics-view policies. An MCP server makes governed metrics available to Claude, ChatGPT, and other agents. Rill states that it has SOC 2 Type 2. Pricing starts at $20/user/mo with a 30-day trial; Starter is $20 per seat monthly, while Growth is $30 per seat monthly.

Who it suits

Rill suits teams building governed analytics on existing warehouses, including those that need embeddable dashboards or to expose metrics to AI agents. It also fits organizations that manage data definitions in SQL and YAML or need row- and column-level controls.

Limits

Starter is $20 a month per seat with up to 20 seats, three projects, embedded analytics previews only, and compute billed separately. Growth is $30 a month per seat with up to 100 seats, ten projects, $500 per month of embedded analytics for up to 100 active embedded seats, and compute billed separately.

Getting started

1. Open https://www.rilldata.com/product
2. Start with the available free access and usage credit
3. Install Rill Developer on macOS or Linux, or use Windows through WSL
4. Connect a supported warehouse, database, storage service, or listed integration
5. Define sources, models, metrics, and dashboards in SQL and YAML
6. Select a plan and configure access, embedding, or agent connections

Verdict

Rill combines SQL-defined metrics with dashboards, embedding, access policies, and an API for querying governed views. Check the project and seat limits, separate compute charges, and deployment requirements against your setup.