# Lightdash vs Preset

**Leader by Vioscale score:** Preset

| Attribute | Lightdash | Preset |
|---|---|---|
| **Vioscale score** | 60.3 (75% (high)) | 74.2 (73% (medium)) |
| activity.commits_last_30d | 100 | - |
| adoption.dependent_repos | 14 | - |
| adoption.github_stars | 6,084 | - |
| deployment.options | `{"cloud":true,"on_prem":true,"self_hosted":true}` | `{"cloud":true,"hybrid":true,"self_hosted":true}` |
| description.long | 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. | A managed analytics platform offering cloud, on-premises, and embedded deployment options for creating interactive dashboards and charts. Built on Apache Superset with features including SQL editing, semantic layers, row-level security, and AI-driven chatbot capabilities for natural language queries. |
| features.capabilities | `{"nlq_ai":true,"rls_sso":true,"paradigm":"governed_dashboards","free_tier":true,"dbt_native":true,"managed_cloud":true,"self_hostable":true,"semantic_layer":"dbt","warehouse_native":true,"connector_breadth":"9 data warehouses (BigQuery, Snowflake, Redshift, Databricks, Postgres, Trino, C","scheduled_reports":true,"embedded_analytics":true,"transparent_pricing":true}` | `{"nlq_ai":true,"rls_sso":true,"paradigm":"governed_dashboards","free_tier":true,"dbt_native":true,"managed_cloud":true,"self_hostable":true,"semantic_layer":"built_in","warehouse_native":true,"connector_breadth":"Popular SQL databases with 40+ visualization types","scheduled_reports":true,"embedded_analytics":true,"transparent_pricing":true}` |
| integrations.count | 19 | 12 |
| 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":"Slack"},{"name":"dbt"},{"name":"Claude"},{"name":"Cursor"},{"name":"MCP-compatible AI tools"},{"name":"Auth0"},{"name":"Azure"},{"name":"Google"},{"name":"Okta"},{"name":"AWS"},{"name":"GCP"},{"name":"Azure (cloud deployment regions)"}]` |
| language.primary | TypeScript | - |
| market.availability | `{"hqCountry":"GB","primaryMarkets":["US","EU"],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` | `{"hqCountry":"US","primaryMarkets":["US","EU"],"availabilityScope":"global","availableCountries":[],"notAvailableCountries":[]}` |
| platform.support | `{"cli":true,"web":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":"subscription","plans":[{"free":true,"name":"Starter","summary":"Free forever for up to 5 users","features":["Unlimited dashboards & charts","40+ visualization types","No-code chart builder","Collaborative SQL editor","Semantic layer","In-depth docs & tutorials"],"minSeats":5,"components":[{"kind":"fixed","amount":0,"period":"month","currency":"USD"}],"description":"Explore Superset in the cloud, free forever for small teams","contactSales":false,"includedLimits":{"users":"5","workspaces":"1"}},{"free":false,"name":"Professional","summary":"$20/user/month (billed annually) or $25/user/month (billed monthly). 14-day free trial included","features":["Unlimited users","3 workspaces","Role-based access controls (RBAC)","Scheduled email reports & alerts","Slack integration for alerts","Multi-region support","Standard customer support","AI Chatbot trial (14 days)"],"commitment":"annual","components":[{"kind":"per_unit","unit":"seat","amount":20,"period":"month","currency":"USD"}],"description":"Collaborate securely with your entire organization","contactSales":false},{"free":false,"name":"Enterprise","summary":"Custom pricing. Volume discounts available","features":["Additional workspaces","dbt integration","Managed Private Cloud deployment","Database connection via SSH tunnels","Single sign-on (SSO) + SCIM integration","Audit logs & usage metrics","Enterprise SLA","AI Chatbot with bring-your-own API key","MCP Server integration"],"description":"Deployment at scale with AI agent access for large organizations","contactSales":true}],"addOns":[{"name":"Embedded dashboard viewer licenses","components":[{"kind":"fixed","amount":500,"period":"month","currency":"USD","description":"for 50 licenses"}]},{"name":"API access"},{"name":"Dedicated support via Slack"}],"summary":"From $20/user/month (billed annually). Free tier available. Enterprise custom pricing.","currency":"USD","freeTier":true,"sourceUrl":"https://preset.io/pricing/","retrievedAt":"2026-08-13T22:22:12.325Z","freeTrialDays":14,"startingPrice":{"amount":20,"period":"month","currency":"USD"},"billingPeriods":["month","year"]}` |
| pricing.free_tier | yes | yes |
| pricing.model | freemium | freemium |
| pricing.price_level | high | mid |
| pricing.transparent | yes | yes |
| release.history | `[{"url":"https://github.com/lightdash/lightdash/releases/tag/2.17.0","date":"2026-08-26T17:18:55Z","type":"stable","version":"2.17.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.16.0","date":"2026-08-26T17:05:03Z","type":"stable","version":"2.16.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.15.0","date":"2026-08-26T16:43:05Z","type":"stable","version":"2.15.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.14.0","date":"2026-08-26T16:01:16Z","type":"stable","version":"2.14.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.13.2","date":"2026-08-26T14:54:11Z","type":"stable","version":"2.13.2"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.13.1","date":"2026-08-26T14:28:49Z","type":"stable","version":"2.13.1"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.13.0","date":"2026-08-26T14:21:42Z","type":"stable","version":"2.13.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.12.0","date":"2026-08-26T13:52:20Z","type":"stable","version":"2.12.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.11.0","date":"2026-08-26T13:33:13Z","type":"stable","version":"2.11.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.10.1","date":"2026-08-26T13:20:20Z","type":"stable","version":"2.10.1"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.10.0","date":"2026-08-26T12:34:23Z","type":"stable","version":"2.10.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.9.5","date":"2026-08-26T12:15:38Z","type":"stable","version":"2.9.5"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.9.4","date":"2026-08-26T11:58:01Z","type":"stable","version":"2.9.4"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.9.3","date":"2026-08-26T11:52:38Z","type":"stable","version":"2.9.3"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.9.2","date":"2026-08-26T11:19:20Z","type":"stable","version":"2.9.2"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.9.1","date":"2026-08-26T11:12:15Z","type":"stable","version":"2.9.1"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.9.0","date":"2026-08-26T10:56:59Z","type":"stable","version":"2.9.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.8.0","date":"2026-08-26T10:47:37Z","type":"stable","version":"2.8.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.7.0","date":"2026-08-26T10:18:01Z","type":"stable","version":"2.7.0"},{"url":"https://github.com/lightdash/lightdash/releases/tag/2.6.0","date":"2026-08-26T09:47:36Z","type":"stable","version":"2.6.0"}]` | - |
| reliability.status_page | yes | yes |
| security.disclosure_policy | - | yes |
| security.gdpr | yes | yes |
| security.hipaa | yes | yes |
| security.iso27001 | - | yes |
| security.pci | - | yes |
| security.soc2 | yes | yes |
| security.vulnerabilities | `{"count":0,"source":"https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=%40lightdash%2Fwarehouses&per_page=100","last_12m":0,"max_severity":null}` | - |

## Capabilities (BI Software)

| Capability | Lightdash | Preset |
|---|:--:|:--:|
| **Core** |  |  |
| BI paradigm | Governed dashboards | Governed dashboards |
| 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 | Popular SQL databases with 40+ visualization types |

*Source: Vioscale. Generated 2026-09-01T17:24:21.003Z. "-" = undocumented, not absent.*