Rill Metrics SQL
SQL-based semantic layer for governed metrics, APIs, and dashboards.
At a glance
- Editor score8.2 / 10
- PricingFrom $20/user/mo · 30-day trial
- Best forAffordable metrics APIs with open-source flexibility
- Free planNo
- Governed metricsYes
- Facts checked20 Sep 2026
Where it wins
- Governed metrics with inherited row-level security policies
- HTTP APIs, dashboards, embedding, and connected applications
- Open-source access with broad warehouse and database connectivity
Where it doesn't
- No perpetual free plan
- Starter limits API calls and token allowances per seat
- Embedded analytics previews only on Starter
Our verdict on Rill Metrics SQL
Rill Metrics SQL is a SQL-based semantic layer for data engineers, analytics engineers, BI developers, platform teams, and organizations building internal or embedded analytics. Teams can define dimensions, measures, and time grains in metrics views, then query governed metrics through Metrics SQL, HTTP APIs, dashboards, CLI tooling, and connected applications. It is available through Rill Developer for local development and Rill Cloud for managed deployment, with web, macOS, Linux, and API access.
The published plans start with Starter at $20 per seat per month, billed monthly, with a 30-day trial. Starter includes unlimited dashboards, reports, and alerts, plus 1M tokens and 2,500 API calls per seat per month. Embedded analytics are available as previews only. Growth costs $30 per seat per month and adds embedded analytics, 2M tokens per seat plus an embedded token allowance, 5,000 API calls per seat per month, and 24/7/365 support with a 6-hour response time. Enterprise adds dedicated infrastructure, unlimited projects, unlimited active embedded seats, custom quotas, an SLA, and a dedicated account manager.
Its strongest fit is for teams that want governed metric definitions to serve multiple interfaces without abandoning SQL or version control. Rill connects with ClickHouse, Databricks, Druid, DuckDB, Google BigQuery, Snowflake, Redshift, PostgreSQL, and other listed systems, while SQL and YAML support version-controlled analytics assets. Integrations with Claude, Gemini, OpenAI, and Slack extend its application ecosystem. Choose Rill when APIs, row-level security, dashboards, embedding, and open-source flexibility matter together. Teams seeking a perpetual free plan or full embedded analytics on the entry tier should consider alternatives.
Rill Metrics SQL pricing
All 3 Rill Metrics SQL plans and prices →
Rill Metrics SQL fact sheet
| Free plan | No |
|---|---|
| Paid from | Not verified |
| Governed metrics | Yes |
| Dimensions and joins | Yes |
| Row-level security | Yes |
| Certified models | Not verified |
| Query API | Yes |
| Deployment model | Hybrid |
| Free trial | 30 days · no card needed |
| Deployment | Cloud, Desktop |
| Platforms | Web, macOS, Linux |
| Compliance & security | SOC 2, SSO/SAML |
| Support | Email, Live chat, Community, Docs |
| Built for | Small business, Mid-market, Enterprise (editorial estimate) |
| Integrations | 20 integrations: ClickHouse, Databricks, Druid, DuckDB, DuckLake, Google BigQuery … See all → |
| Pricing | From $20/user/mo · 30-day trial (source) |
| Website | rilldata.com |
| Facts checked | 20 Sep 2026 |
Rill Metrics SQL integrations
Rill Metrics SQL lists 20 integrations on its own site.
- ClickHouse
- Databricks
- Druid
- DuckDB
- DuckLake
- Google BigQuery
- MotherDuck
- Pinot
- Snowflake
- StarRocks
- Amazon Athena
- Redshift
- MySQL
- PostgreSQL
- SQLite
- Supabase
- Amazon S3
- Google Cloud Storage
- Microsoft Azure Blob Storage
- Delta Lake
See all Rill Metrics SQL integrations →
Alternatives to Rill Metrics SQL
- CubeA governed semantic layer for teams building internal and embedded analytics.8.2
- AtScaleA strong fit for enterprise teams standardizing governed metrics across BI and AI.8.2
- GoodDataA strong fit for teams building governed, embedded analytics across multiple data sources.7.2
See all Rill Metrics SQL alternatives →
Used Rill Metrics SQL? Be the first to review it
The editor score above is our own research. What this page doesn't have yet is a reader's view — what you used Rill Metrics SQL for, what worked and what didn't. No stars are seeded and no review is paid for; an editor reads every one before it appears.
Write a reviewTwo minutes · verified accounts only · read by an editor before it appears
Featured on iTechGuides
Rill Metrics SQL is listed in our Semantic Layer Software directory. Add the badge to your site — it links back to this page.
<a href="https://www.itechguides.com/products/rill-metrics-sql/"><img src="https://www.itechguides.com/best/badge/rill-metrics-sql.svg" alt="Featured on iTechGuides" width="230" height="46"></a>
Reviewed by iTechGuides Editors · Editorial team · Updated Sep 2026
Advertiser disclosure: iTechGuides is reader-supported. We may earn a commission when you click some links. It never changes a score or a verdict. How we rank.