Comparison

Lightdash vs Preset

On the evidence we track, Preset leads this comparison with a composite score of 74/100. Scores are only directly comparable because these tools share a category; the full breakdown and every source is below.

Lightdash full profile →Preset full profile →

Machine formatsJSON Markdown GraphQLor send Accept: application/json

Lightdash60

★Preset74

Attribute comparison across 2 tools
Attribute	Lightdash	PresetLeader
Vioscale score	60 / 100high · 75%	74 / 100medium · 73%
Pricing
Free tierpricing.free_tier	✓	✓
Modelpricing.model	freemium	freemium
Price levelpricing.price_level	high	mid
Transparentpricing.transparent	✓	✓
Integrations
Countintegrations.count	19	12
Security
Disclosure policysecurity.disclosure_policy	-	✓
Gdprsecurity.gdpr	✓	✓
Hipaasecurity.hipaa	✓	✓
Iso27001security.iso27001	-	✓
Pcisecurity.pci	-	✓
Soc2security.soc2	✓	✓
Vulnerabilitiessecurity.vulnerabilities	Count: 0 · Source: https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=%40lightdash%2Fwarehouses&per_page=100 · Last 12m: 0	-
Reliability
Status pagereliability.status_page	✓	✓
Adoption
Dependent reposadoption.dependent_repos	14	-
Github starsadoption.github_stars	6,084	-
Activity
Commits last 30dactivity.commits_last_30d	100	-
Release
Historyrelease.history	20 items	-
Language
Primarylanguage.primary	TypeScript	-
Market
Availabilitymarket.availability	Available worldwide · Popular in US, EU · HQ GB	Available worldwide · Popular in US, EU · HQ US

Score

Vioscale score

Lightdash60 / 100high · 75%

Preset74 / 100medium · 73%

Pricing

Free tier

Lightdash✓

Preset✓

Model

Lightdashfreemium

Presetfreemium

Price level

Lightdashhigh

Presetmid

Transparent

Lightdash✓

Preset✓

Integrations

Count

Lightdash19

Preset12

Security

Disclosure policy

Lightdash–

Preset✓

Gdpr

Lightdash✓

Preset✓

Hipaa

Lightdash✓

Preset✓

Iso27001

Lightdash–

Preset✓

Pci

Lightdash–

Preset✓

Soc2

Lightdash✓

Preset✓

Vulnerabilities

LightdashCount: 0 · Source: https://advisories.ecosyste.ms/api/v1/advisories?ecosystem=npm&package_name=%40lightdash%2Fwarehouses&per_page=100 · Last 12m: 0

Preset–

Reliability

Status page

Lightdash✓

Preset✓

Adoption

Dependent repos

Lightdash14

Preset–

Github stars

Lightdash6,084

Preset–

Activity

Commits last 30d

Lightdash100

Preset–

Release

History

Lightdash20 items

Preset–

Language

Primary

LightdashTypeScript

Preset–

Market

Availability

LightdashAvailable worldwide · Popular in US, EU · HQ GB

PresetAvailable worldwide · Popular in US, EU · HQ US

Capabilities

Feature-by-feature on the axes that matter for bi software. “-” means undocumented, not absent.

Capability comparison for 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

Core

BI paradigm

LightdashGoverned dashboards

PresetGoverned dashboards

Semantic / modelling layer

Lightdashdbt metrics

PresetBuilt-in

Engine

Warehouse-native (SQL push-down)

Lightdash✓

Preset✓

Deployment

Self-hostable / OSS core

Lightdash✓

Preset✓

Managed cloud available

Lightdash✓

Preset✓

Intelligence

Natural-language query / AI copilot

Lightdash✓

Preset✓

Delivery

Embedded / white-label analytics

Lightdash✓

Preset✓

Scheduled reports / alerting

Lightdash✓

Preset✓

Governance

Row-level security & SSO/SAML

Lightdash✓

Preset✓

Commercial

Per-seat pricing published

Lightdash✓

Preset✓

Free tier / free desktop

Lightdash✓

Preset✓

Ecosystem

dbt-native integration

Lightdash✓

Preset✓

Data-source connector breadth

Lightdash9 data warehouses (BigQuery, Snowflake, Redshift, Databricks, Postgres, Trino, C

PresetPopular SQL databases with 40+ visualization types

What each one is

The product in its own terms, so the numbers below have context.

Lightdash

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.

Independently observed

Preset

Leader

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.

Independently observed

Pricing

List pricing as published by each vendor, with the date we read it. Always verify at the source before you buy.

Lightdash

from $3000/moHybridFree tier21-day trial

Open source free tier, Cloud Pro at $3,000/month (unlimited users), Enterprise custom. No per-seat pricing.

Open SourceFree
- Unlimited seats
- Data explorer and report builder
- Native dbt integration
- Scheduled deliveries
- Alerting
- +11 more
Cloud Pro$3,000/month flat rate, unlimited users and visualizations
- Unlimited users
- Unlimited visualizations
- Native dbt integration with open semantic layer
- Scheduled reports and alerting
- Dashboards as code
- +11 more
EnterpriseContact sales
- 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
- +9 more

as of 2026-08-14verify ↗

Preset

Leader

from $20/moSubscriptionFree tier14-day trial

From $20/user/month (billed annually). Free tier available. Enterprise custom pricing.

StarterFree
- Unlimited dashboards & charts
- 40+ visualization types
- No-code chart builder
- Collaborative SQL editor
- Semantic layer
- +1 more
Professional$20/user/month (billed annually) or $25/user/month (billed monthly). 14-day free trial included
- Unlimited users
- 3 workspaces
- Role-based access controls (RBAC)
- Scheduled email reports & alerts
- Slack integration for alerts
- +3 more
EnterpriseContact sales
- Additional workspaces
- dbt integration
- Managed Private Cloud deployment
- Database connection via SSH tunnels
- Single sign-on (SSO) + SCIM integration
- +4 more

as of 2026-08-13verify ↗

Platform & deployment

Where each product runs and how it can be hosted. A dash means undocumented, not unsupported.

Platform and deployment support comparison
Supports	Lightdash	Preset
WebPlatforms	✓	✓
CLIPlatforms	✓	✗
Cloud / SaaSDeployment	✓	✓
Self-hostedDeployment	✓	✓
On-premiseDeployment	✓	✗
HybridDeployment	✗	✓

Platforms

Web

Lightdash✓

Preset✓

CLI

Lightdash✓

Preset✗

Deployment

Cloud / SaaS

Lightdash✓

Preset✓

Self-hosted

Lightdash✓

Preset✓

On-premise

Lightdash✓

Preset✗

Hybrid

Lightdash✗

Preset✓

Integrations

What each product connects to. Counts come from the vendor's own integration directory where one exists.

In common (2)

Slack
dbt

Lightdash

19 total - 17 not shared

BigQuery
Snowflake
Redshift
Databricks
Postgres
Trino
ClickHouse
Athena
DuckDB
GitHub
GitLab
Azure DevOps
Bitbucket
Microsoft Teams
Google Sheets
Rollstack
MotherDuck

Independently observed

Preset

Leader

12 total - 10 not shared

Claude
Cursor
MCP-compatible AI tools
Auth0
Azure
Google
Okta
AWS
GCP
Azure (cloud deployment regions)

Independently observed

Comparison generated from independently-sourced facts. Every value links to its source and retrieval date. See the method.