# Lightdash vs Spotfire

**Leader by Vioscale score:** Lightdash

| Attribute | Lightdash | Spotfire |
|---|---|---|
| **Vioscale score** | 60.3 (75% (high)) | 45 (20% (low)) |
| 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,"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. | Spotfire is a visual analytics platform designed for industrial organizations where decision-making involves complex, fragmented data sources. It unifies data exploration, analytics, and AI in a shared environment, enabling engineers and domain experts to collaborate and transition from scattered insights to decisive action. |
| 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,"paradigm":"governed_dashboards","self_hostable":true,"connector_breadth":"SQL databases, Python, R, real-time data streams, time-series data, and spatial ","scheduled_reports":true,"embedded_analytics":true}` |
| integrations.count | 19 | 4 |
| 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":"SQL Server"},{"name":"Python"},{"name":"R"},{"name":"TIBCO Data Virtualization"}]` |
| language.primary | TypeScript | - |
| market.availability | `{"hqCountry":"GB","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"]}` | - |
| pricing.free_tier | yes | - |
| pricing.model | freemium | commercial |
| pricing.price_level | high | - |
| pricing.transparent | 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.gdpr | yes | - |
| security.hipaa | yes | - |
| security.soc2 | 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 | Spotfire |
|---|:--:|:--:|
| **Core** |  |  |
| BI paradigm | Governed dashboards | Governed dashboards |
| Semantic / modelling layer | dbt metrics | - |
| **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, Python, R, real-time data streams, time-series data, and spatial |

*Source: Vioscale. Generated 2026-09-01T14:39:42.416Z. "-" = undocumented, not absent.*