| Category | AI-native analytics engine with an integrated data stack | Open-source BI for dbt teams, positioned as agentic BI |
|---|
| Who it is built for | AI product and analytics teams, plus anyone who works with data — spreadsheet users through ML engineers | Analytics engineers and data teams who already work in dbt |
|---|
| Primary interface | The agent you already use, over MCP — plus Workspaces, notebooks, reports and data apps for the people who want a UI. All of them consume the same model rather than being the place it lives | Its own UI — a metrics catalog, charts and dashboards — with AI agents in the app, in Slack and in Teams |
|---|
| Modeling language | Malloy — a modeling and query language with imports, inheritance, and public and private members | YAML — metrics and dimensions defined in your dbt project, or in Lightdash YAML if you do not have one |
|---|
| What is open | Open core. Malloy is open source, and we build and maintain Malloy Publisher, the open-source server for Malloy models. Your model is code in your repository, and Credible is in the Apache Ossie ecosystem for semantic interchange | Open core — core BI features are MIT-licensed and self-hostable; advanced security, customization, support and Lightdash Cloud are commercial |
|---|
| How the model gets built | A coding agent with open-source MCP tools and agent skills, capturing context from where it already lives | Hand-authored YAML beside your dbt models, with agents that propose changes back to the layer for review |
|---|
| Governance | Governance as code. Access rules are annotations in the model itself — versioned, reviewed and composable like any other code | Project and space permissions plus user attributes for row-level access, and an agent answers as the person asking |
|---|
| Materialization and caching | One annotation on the source, in the same file as the logic it materializes — no derived-table block, no rollup definitions, no refresh triggers, no orchestration run to schedule. Optional per source: query your own warehouse directly, or hold a source hot in Credible’s in-memory serving layer, which is how a team on Postgres gets fast serving without buying a warehouse to get it | Caching declared in the context layer alongside the metrics; heavier materialization stays upstream in dbt |
|---|
| How an agent finds the right data | Search. Typed targets — source, dimension, measure, view, even a dimensional value — are matched against an index of the model and come back ranked, so an agent asks for what it needs instead of picking a model and touring it | The agent selects models and metrics out of the semantic layer, with knowledge documents you upload as extra context, and a router sends a question to the team agent scoped to it |
|---|
| Where the model can be used | One model served to every surface — agents over MCP, plus APIs, an SDK, embedded dashboards, notebooks and HTML data apps. Results carry an interactive UI resource (MCP Apps, the official extension), so a client that supports it renders a real chart or table instead of the model re-narrating rows | The Lightdash UI, Slack and Teams, a REST API, a Python SDK, an SDK for embedding dashboards, agents and data apps, and the Lightdash MCP server |
|---|
| Scale and portability | Built for globally distributed, high-availability workloads. Warehouse-agnostic on open-source Malloy — BigQuery, Snowflake, Postgres, MySQL, Trino, Presto and DuckDB, which also reads Parquet straight out of object storage including Azure Data Lake — so the model travels | Self-hosted or Lightdash Cloud, over BigQuery, Snowflake, Redshift, Databricks, Postgres, Trino and ClickHouse |
|---|
| What you pay for | Usage, not seats — unlimited users on every plan, so adding people never changes the bill. Metered per organization on tokens, bytes processed, bytes served and hot storage, starting free. Your own agent’s tokens are never billed, and a query that runs on your own warehouse is not metered for the scan — only for the result it hands back | A flat platform fee for unlimited users on Cloud, nothing if you self-host, with embedded loads metered separately |
|---|