vioscaleAI
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 formatsMarkdownJSONGraphQLMarkdown is open. JSON and GraphQL need a free key.
Lightdash64
★Preset74
Score
vioscaleAI score
Lightdash64 / 100medium · 73%
Preset74 / 100medium · 68%
Pricing
Free tier
Lightdash✓
Preset✓
Model
Lightdashfreemium
Presetfreemium
Price level
Lightdashlow
Presetmid
Transparent
Lightdash✓
Preset✓
Integrations
Count
Lightdash13
Preset12
Security
Certifications
LightdashSOC 2 Type II
Preset–
Disclosure policy
Lightdash–
Preset✓
Gdpr
Lightdash✓
Preset✓
Hipaa
Lightdash✓
Preset✓
Iso27001
Lightdash–
Preset✓
Pci
Lightdash–
Preset✓
Soc2
Lightdash✓
Preset✓
Trust center
Vulnerabilities
Reliability
Status page
Lightdash✓
Preset✓
Adoption
Dependent repos
Lightdash14
Preset–
Github stars
Lightdash6,185
Preset–
Activity
Commits last 30d
Lightdash100
Preset–
Release
History
Lightdash20 items
Preset–
Language
Primary
LightdashTypeScript
Preset–
Market
Availability
Content
Faq
Lightdash7 items
Preset7 items

Capabilities

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

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

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.

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 verify ↗

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 verify ↗

Platform & deployment

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

Platforms
Web
Lightdash✓
Preset✓
CLI
Lightdash✓
Preset✗
Deployment
Cloud / SaaS
Lightdash✓
Preset✓
Self-hosted
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

21 total - 19 not shared
  • BigQuery
  • Snowflake
  • Redshift
  • Databricks
  • Postgres
  • Trino
  • ClickHouse
  • Athena
  • DuckDB
  • GitHub
  • GitLab
  • Azure DevOps
  • Bitbucket
  • Microsoft Teams
  • Google Sheets
  • Rollstack
  • MotherDuck
  • Google Slides
  • PowerPoint
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
Still deciding?

Lightdash or Preset: which one depends on you

A composite score cannot know your constraints. Describe them and both get re-weighted against what you actually need, with the evidence behind every position.

Free to run, no account needed to start. How the evaluation works

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