# Lightdash vs Rill

| Attribute | Lightdash | Rill |
|---|---|---|
| **vioscaleAI score** | 64.2 (73% (medium)) | 64 (75% (high)) |
| activity.commits_last_30d | 100 | 100 |
| adoption.dependent_repos | 14 | 0 |
| adoption.github_stars | 6,185 | 2,941 |
| content.faq | `[{"answer":"A BI platform that anchors analytics in dbt-defined metrics and provides a governed semantic layer for organizations. Teams define metrics, joins, and business logic once, then access the data through dashboards, AI-powered Q&A, embedded analytics, or custom data applications, all with consistent governance and user permissions. It is indexed under BI Software.","source":"https://www.lightdash.com/pricing","question":"What is Lightdash?","confidence":0.6},{"answer":"Lightdash offers a free tier, so you can start without paying. Paid plans start at $3000 per month. Prices are published openly on the vendor's own pricing page. Pricing changes often, so verify at source before relying on it.","source":"https://www.lightdash.com/pricing","question":"Is Lightdash free?","confidence":0.6},{"answer":"Lightdash supports the web and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://www.lightdash.com/pricing","question":"What platforms does Lightdash support?","confidence":0.6},{"answer":"Yes. Lightdash can be deployed cloud / SaaS, on-premise and self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://www.lightdash.com/pricing","question":"Can Lightdash be self-hosted?","confidence":0.6},{"answer":"We have confirmed 19 integrations for Lightdash, including BigQuery, Snowflake, Redshift, Databricks, Postgres, Trino, ClickHouse and Athena, plus 11 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://www.lightdash.com/pricing","question":"What does Lightdash integrate with?","confidence":0.6},{"answer":"We have independently confirmed SOC 2, HIPAA and GDPR for Lightdash. Certifications we do not list are ones we have not been able to verify from public sources, which is not the same as Lightdash not holding them. Always confirm compliance directly before you rely on it.","source":"https://www.lightdash.com/pricing","question":"What security certifications does Lightdash have?","confidence":0.6},{"answer":"Lightdash is available worldwide. Its primary markets are the United States and the EU. The vendor is headquartered in the United Kingdom.","source":"https://www.lightdash.com/pricing","question":"Where is Lightdash available?","confidence":0.75}]` | `[{"answer":"Platform for building analytics with metrics defined in code, then accessed via dashboards, natural language questions, and APIs. Works with multiple data sources and integrates with AI tools for faster insights. It is indexed under BI Software.","source":"https://www.rilldata.com/pricing","question":"What is Rill?","confidence":0.6},{"answer":"Rill offers a free tier, so you can start without paying. Paid plans start at $0.10. Prices are published openly on the vendor's own pricing page. Pricing changes often, so verify at source before relying on it.","source":"https://www.rilldata.com/pricing","question":"Is Rill free?","confidence":0.6},{"answer":"Rill supports the web and a command-line interface. Platforms we have not confirmed are simply not listed here rather than ruled out.","source":"https://www.rilldata.com/pricing","question":"What platforms does Rill support?","confidence":0.6},{"answer":"Yes. Rill can be deployed cloud / SaaS, hybrid and self-hosted, so it does not have to run on the vendor's infrastructure.","source":"https://www.rilldata.com/pricing","question":"Can Rill be self-hosted?","confidence":0.6},{"answer":"We have confirmed 14 integrations for Rill, including Claude Code, Cursor, ChatGPT, S3, Google Cloud Storage, ClickHouse, DuckDB and MotherDuck, plus 6 more. This is what we could verify from public sources, so the vendor may support others we have not indexed.","source":"https://www.rilldata.com/pricing","question":"What does Rill integrate with?","confidence":0.6},{"answer":"We have independently confirmed SOC 2 for Rill. Certifications we do not list are ones we have not been able to verify from public sources, which is not the same as Rill not holding them. Always confirm compliance directly before you rely on it.","source":"https://trust.rilldata.com","question":"What security certifications does Rill have?","confidence":0.7},{"answer":"Yes. Rill is published under the Apache-2.0 licence, a permissive licence that generally allows commercial use and modification. Licence terms can change between releases, so verify against the repository for the version you intend to use.","source":"https://github.com/rilldata/rill","question":"Is Rill open source?","confidence":0.95},{"answer":"Rill is available worldwide. Its primary market is the United States.","source":"https://www.rilldata.com/pricing","question":"Where is Rill available?","confidence":0.5}]` |
| deployment.options | `{"cloud":true,"self_hosted":true}` | `{"cloud":true,"self_hosted":true}` |
| description.long | An agentic BI platform that defines trusted metrics and business logic in dbt, then powers self-serve analytics across dashboards, natural-language AI agents, and embedded data apps. Available as open-source for self-hosting or managed cloud. | A business intelligence tool designed for both AI agents and human users, built on OLAP engines like ClickHouse and DuckDB. It uses code-driven configuration (YAML and SQL), provides a semantic layer for consistent metric definitions, supports conversational queries in natural language, and includes interactive dashboards with row-level access control. |
| features.capabilities | `{"nlq_ai":true,"hosting":"both","rls_sso":true,"paradigm":"governed_dashboards","free_tier":true,"dbt_native":true,"data_modeling":true,"managed_cloud":true,"self_hostable":true,"git_versioning":true,"semantic_layer":"dbt","visualizations":true,"warehouse_native":true,"connector_breadth":"9 data warehouses (BigQuery, Snowflake, Redshift, Databricks, Postgres, Trino, C","scheduled_reports":true,"embedded_analytics":true,"transparent_pricing":true,"self_serve_dashboards":true}` | `{"nlq_ai":true,"hosting":"both","rls_sso":true,"paradigm":"semantic_layer","free_tier":true,"api_access":true,"sql_editor":true,"data_modeling":true,"managed_cloud":true,"self_hostable":true,"git_versioning":true,"semantic_layer":"built_in","visualizations":true,"warehouse_native":true,"connector_breadth":"SQL databases, S3, Google Cloud Storage, and 20+ connectors","scheduled_reports":true,"embedded_analytics":true,"transparent_pricing":true,"self_serve_dashboards":true}` |
| integrations.count | 13 | 20 |
| integrations.list | `[{"name":"BigQuery"},{"name":"Snowflake"},{"name":"Redshift"},{"name":"Databricks"},{"name":"Postgres"},{"name":"Trino"},{"name":"ClickHouse"},{"name":"Athena"},{"name":"DuckDB"},{"name":"GitHub"},{"name":"GitLab"},{"name":"Azure DevOps"},{"name":"Bitbucket"},{"name":"Slack"},{"name":"Microsoft Teams"},{"name":"Google Sheets"},{"name":"dbt"},{"name":"Rollstack"},{"name":"MotherDuck"},{"name":"Google Slides","native":true,"category":"presentations","direction":"outbound"},{"name":"PowerPoint","native":true,"category":"presentations","direction":"outbound"}]` | `[{"name":"Claude Code"},{"name":"Cursor"},{"name":"ChatGPT"},{"name":"S3"},{"name":"Google Cloud Storage"},{"name":"ClickHouse"},{"name":"ClickHouse Cloud"},{"name":"DuckDB"},{"name":"MotherDuck"},{"name":"Druid"},{"name":"Pinot"},{"name":"Google SSO"},{"name":"Microsoft SSO"},{"name":"Okta"},{"name":"SAML"},{"name":"GCS","native":true,"category":"cloud_storage","direction":"inbound"}]` |
| language.primary | TypeScript | Go |
| license.spdx | - | Apache-2.0 |
| market.availability | `{"hqCountry":"GB","primaryMarkets":["US","EU"],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | `{"primaryMarkets":["US"],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | `{"cli":true,"web":true}` | `{"cli":true,"web":true}` |
| pricing | `{"type":"hybrid","plans":[{"free":true,"name":"Open Source","summary":"Free, self-hosted, community support","features":["Unlimited seats","Data explorer and report builder","Native dbt integration","Scheduled deliveries","Alerting","Google Sheets sync","SQL runner","Private spaces","Global search","Version history (3 days)","Basic usage analytics","API & webhooks","Smart caching","Pre-aggregates","8 data warehouse connections","4 git platform integrations"],"components":[{"kind":"fixed","amount":0,"period":"month","currency":"USD"}],"description":"Self-hosted core BI for teams managing their own infrastructure","contactSales":false},{"free":false,"name":"Cloud Pro","summary":"$3,000/month flat rate, unlimited users and visualizations","features":["Unlimited users","Unlimited visualizations","Native dbt integration with open semantic layer","Scheduled reports and alerting","Dashboards as code","Metrics catalog and governed explorer","AI agents for natural language queries","MCP (Model Context Protocol) support","Dedicated human support","Guided onboarding and training sessions","Automated migration from other BI tools","Version history (30 days)","Advanced usage analytics","Embedding via iframe and React SDK (add-on)","US and EU deployment regions","SSO via Google, Okta, Azure, custom OIDC"],"components":[{"kind":"fixed","amount":3000,"period":"month","currency":"USD"}],"description":"Managed cloud platform with unlimited users, AI agents, and governance","contactSales":false},{"free":false,"name":"Enterprise","summary":"Custom pricing, available on-premises or cloud","features":["All Cloud Pro features, plus:","Cloud or on-premises deployment","SAML 2.0 and SCIM 2.0 provisioning","Advanced user management with custom roles","SOC 2 Type II compliance","HIPAA and BAA support","Hands-on migration with on-site assistance","Priority support with 8-hour response SLA","Dedicated account manager","Dedicated Slack support channel","Early access to new features","Version history (60 days)","Custom usage analytics","Custom deployment regions"],"description":"Custom deployment and advanced security for large-scale deployments","contactSales":true}],"addOns":[{"name":"Embedding per load","components":[{"per":{"qty":1,"unit":"load"},"kind":"metered","amount":0.05,"currency":"USD"}]},{"name":"Embedding predictable","components":[{"kind":"fixed","amount":790,"period":"month","currency":"USD"}]},{"name":"HIPAA BAA (Cloud Pro)","components":[{"kind":"fixed","amount":490,"period":"month","currency":"USD"}]},{"name":"Data Apps"}],"summary":"Open source free tier, Cloud Pro at $3,000/month (unlimited users), Enterprise custom. No per-seat pricing.","currency":"USD","freeTier":true,"sourceUrl":"https://www.lightdash.com/pricing","retrievedAt":"2026-08-14T13:45:42.627Z","freeTrialDays":21,"startingPrice":{"amount":3000,"period":"month","currency":"USD"},"billingPeriods":["month"]}` | `{"type":"hybrid","plans":[{"free":false,"name":"Starter","summary":"$20/seat/month + $0.15/compute unit-hour","features":["Platform access","Unlimited dashboards, reports, alerts","Embedded analytics (previews only)","Agentic analytics (1M tokens/seat/month)","API access (2,500 calls/seat/month, $0.01/call overage)","Support (1 business day response time)","Single AZ, non-replicated","Google/Microsoft SSO"],"commitment":"monthly","components":[{"kind":"per_unit","unit":"seat","amount":20,"period":"month","currency":"USD"},{"per":{"qty":1,"unit":"compute unit-hour"},"kind":"metered","amount":0.15,"currency":"USD"},{"per":{"qty":1,"unit":"GB/month"},"kind":"metered","amount":0.1,"currency":"USD"}],"description":"Small teams getting started with Rill Cloud","contactSales":false,"includedLimits":{"seats":"20","projects":"3","api_calls":"2,500/seat/month","agentic_analytics_tokens":"1M/seat/month","managed_database_storage":"10GB"}},{"free":false,"name":"Growth","summary":"$30/seat/month + $500/month embedded + $0.20/compute unit-hour","features":["Platform access","Unlimited dashboards, reports, alerts","Embedded analytics ($500/month up to 100 active seats)","Agentic analytics (2M tokens/seat + 200k/embedded)","API access (5,000 calls/seat + 500/embedded, $0.01/call overage)","Support (6 hour response time, 24/7/365)","Multi-AZ, replicated","Google/Microsoft SSO, Okta, SAML, Custom IdP","Custom branding and white-labeling","VPC Peering/PrivateLink","Committed Use Discounts"],"commitment":"monthly","components":[{"kind":"per_unit","unit":"seat","amount":30,"period":"month","currency":"USD"},{"kind":"fixed","amount":500,"period":"month","currency":"USD"},{"per":{"qty":1,"unit":"compute unit-hour"},"kind":"metered","amount":0.2,"currency":"USD"},{"per":{"qty":1,"unit":"GB/month"},"kind":"metered","amount":0.2,"currency":"USD"}],"description":"Teams scaling internal and embedded analytics","contactSales":false,"includedLimits":{"seats":"100","projects":"10","api_calls":"5,000/seat/month + 500/embedded seat/month","embedded_seats_fee":"$500/month for up to 100 active seats","agentic_analytics_tokens":"2M/seat/month + 200k/embedded seat/month","managed_database_storage":"1TB"}},{"free":false,"name":"Enterprise","summary":"Custom annual pricing with unlimited scale","features":["Platform access (unlimited seats)","Unlimited dashboards, reports, alerts","Embedded analytics (unlimited active seats)","Agentic analytics (custom quota)","API access (custom quota)","Support (1 hour response time, 24/7/365, uptime SLA, dedicated account manager)","Dedicated infrastructure","All Growth plan features"],"commitment":"annual","description":"Organizations needing dedicated scale and governance","contactSales":true,"includedLimits":{"seats":"unlimited","projects":"unlimited","api_calls":"custom","embedded_seats":"unlimited","support_response_time":"1 hour","agentic_analytics_tokens":"custom"}}],"summary":"From $20/seat/month. Free tier with $250 credit. Hybrid seat + usage-based pricing","currency":"USD","freeTier":true,"sourceUrl":"https://www.rilldata.com/pricing","retrievedAt":"2026-08-13T22:25:17.008Z","startingPrice":{"amount":0.1,"period":"month","currency":"USD"},"billingPeriods":["month"]}` |
| pricing.free_tier | yes | yes |
| pricing.model | freemium | freemium |
| pricing.price_level | low | low |
| pricing.transparent | yes | yes |
| release.cadence_days | - | 4 |
| release.history | `[{"url":"https://github.com/lightdash/lightdash/releases/tag/2.576.1","date":"2026-10-13T15:01:24Z","type":"stable","version":"2.576.1"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.576.0","date":"2026-10-13T13:28:45Z","type":"stable","version":"2.576.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.575.4","date":"2026-10-13T12:27:41Z","type":"stable","version":"2.575.4"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.575.3","date":"2026-10-13T11:39:39Z","type":"stable","version":"2.575.3"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.575.2","date":"2026-10-13T11:27:25Z","type":"stable","version":"2.575.2"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.575.1","date":"2026-10-13T09:07:30Z","type":"stable","version":"2.575.1"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.575.0","date":"2026-10-13T08:21:30Z","type":"stable","version":"2.575.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.574.0","date":"2026-10-13T03:54:23Z","type":"stable","version":"2.574.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.573.4","date":"2026-10-13T03:12:31Z","type":"stable","version":"2.573.4"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.573.3","date":"2026-10-13T01:07:33Z","type":"stable","version":"2.573.3"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.573.2","date":"2026-10-13T00:06:51Z","type":"stable","version":"2.573.2"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.573.1","date":"2026-10-12T23:04:18Z","type":"stable","version":"2.573.1"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.573.0","date":"2026-10-12T22:26:24Z","type":"stable","version":"2.573.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.572.1","date":"2026-10-12T22:10:21Z","type":"stable","version":"2.572.1"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.572.0","date":"2026-10-12T20:23:40Z","type":"stable","version":"2.572.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.571.2","date":"2026-10-12T18:14:07Z","type":"stable","version":"2.571.2"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.571.1","date":"2026-10-12T17:20:16Z","type":"stable","version":"2.571.1"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.571.0","date":"2026-10-12T17:04:02Z","type":"stable","version":"2.571.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.570.0","date":"2026-10-12T16:59:15Z","type":"stable","version":"2.570.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.569.0","date":"2026-10-12T15:58:39Z","type":"stable","version":"2.569.0"}]` | `[{"url":"https://github.com/rilldata/rill/releases/tag/v0.90.5","date":"2026-10-09T07:26:29Z","type":"stable","version":"v0.90.5"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.90.4","date":"2026-10-07T14:08:35Z","type":"stable","version":"v0.90.4"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.90.3","date":"2026-10-05T06:27:59Z","type":"stable","version":"v0.90.3"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.90.2","date":"2026-09-25T12:21:41Z","type":"stable","version":"v0.90.2"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.90.1","date":"2026-09-24T16:31:04Z","type":"stable","version":"v0.90.1"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.90.0","date":"2026-09-24T08:24:57Z","type":"stable","version":"v0.90.0"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.89.4","date":"2026-09-01T06:52:01Z","type":"stable","version":"v0.89.4"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.89.2","date":"2026-08-26T09:44:37Z","type":"stable","version":"v0.89.2"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.89.1","date":"2026-08-25T06:38:30Z","type":"stable","version":"v0.89.1"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.89.0","date":"2026-08-20T10:25:27Z","type":"stable","version":"v0.89.0"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.88.6","date":"2026-08-03T10:45:54Z","type":"stable","version":"v0.88.6"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.88.5","date":"2026-07-29T17:11:07Z","type":"stable","version":"v0.88.5"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.88.4","date":"2026-07-24T13:41:07Z","type":"stable","version":"v0.88.4"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.88.3","date":"2026-07-23T15:08:35Z","type":"stable","version":"v0.88.3"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.88.2","date":"2026-07-22T12:58:43Z","type":"stable","version":"v0.88.2"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.88.1","date":"2026-07-17T12:05:09Z","type":"stable","version":"v0.88.1"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.88.0","date":"2026-07-16T10:30:46Z","type":"stable","version":"v0.88.0"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.87.8","date":"2026-07-03T09:07:25Z","type":"stable","version":"v0.87.8"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.87.7","date":"2026-06-26T13:43:32Z","type":"stable","version":"v0.87.7"},{"url":"https://github.com/rilldata/rill/releases/tag/v0.87.6","date":"2026-06-25T14:41:47Z","type":"stable","version":"v0.87.6"}]` |
| reliability.status_page | yes | yes |
| security.certifications | `[{"name":"SOC 2 Type II","level":"Type II","status":"active"}]` | - |
| security.gdpr | yes | - |
| security.hipaa | yes | - |
| security.soc2 | yes | yes |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=%40lightdash%2Fcommon&per_page=100","last_12m":0,"max_severity":null}` | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=go&package_name=github.com%2Frilldata%2Frill&per_page=100","last_12m":0,"max_severity":null}` |

## Capabilities (BI Software)

| Capability | Lightdash | Rill |
|---|:--:|:--:|
| **Core** |  |  |
| BI paradigm | Governed dashboards | Semantic layer |
| Semantic / modelling layer | dbt metrics | Built-in |
| **Engine** |  |  |
| Warehouse-native (SQL push-down) | ✓ | ✓ |
| **Deployment** |  |  |
| Self-hostable / OSS core | ✓ | ✓ |
| Managed cloud available | ✓ | ✓ |
| **Intelligence** |  |  |
| Natural-language query / AI copilot | ✓ | ✓ |
| **Delivery** |  |  |
| Embedded / white-label analytics | ✓ | ✓ |
| Scheduled reports / alerting | ✓ | ✓ |
| **Governance** |  |  |
| Row-level security & SSO/SAML | ✓ | ✓ |
| **Commercial** |  |  |
| Per-seat pricing published | ✓ | ✓ |
| Free tier / free desktop | ✓ | ✓ |
| **Ecosystem** |  |  |
| dbt-native integration | ✓ | - |
| Data-source connector breadth | 9 data warehouses (BigQuery, Snowflake, Redshift, Databricks, Postgres, Trino, C | SQL databases, S3, Google Cloud Storage, and 20+ connectors |

*Source: vioscaleAI. Generated 2026-10-15T22:04:56.996Z. "-" = undocumented, not absent.*