Developer Tools · head to head
Fig vs Lightdash
Fig
Developer Tools
IDE-style autocomplete for your existing terminal
- From
- Free
- Free plan
- Yes
Lightdash
Business Intelligence
Open-source BI for dbt users
- From
- Free
- Free plan
- Yes
The short version
- Lightdash is an open-source business intelligence tool.
- Both are free.
- Where Fig falls short: the standalone desktop app is no longer available or supported.
- Where Lightdash falls short: requires existing dbt infrastructure, not suitable for teams without data models.
- Prices and features on this page were last checked on 13 November 2026.
Where they differ
Only the attributes on which Fig and Lightdash actually diverge.
Identical on both: starting price (Free), free tier (Yes).
Not yet recorded: pricing model for Lightdash.
What each one covers
Drawn from each product's published feature list. An absence here means we hold no record of it - not that the product lacks it.
Only in Fig
Nothing recorded that Lightdash does not also cover.
Only in Lightdash
- dbt Integration
- Metrics Layer
- Dashboards
- Scheduling
- Version Control
- dbt
- BigQuery
- Snowflake
What people use each for
The jobs each tool is most often brought in to do.
Fig
No use cases recorded yet. See the Fig review.
Lightdash
- Self-service analyticsnot Fig
- Data explorationnot Fig
- Ad-hoc reportingnot Fig
- Collaborative analysisnot Fig
- Embedded analyticsnot Fig
Where each one falls short
Documented limitations, not opinions. Every one is a constraint you would hit in normal use.
Fig
- Shut down on 1 September 2024. Amazon acquired Fig in August 2023 and folded it into Amazon Q Developer, which now carries the terminal autocomplete
- The standalone desktop app is no longer available or supported
- The completion specs remain open source on GitHub, but the product that consumed them is gone
Lightdash
- Requires existing dbt infrastructure, not suitable for teams without data models
- Enterprise features and AI agents unavailable in open-source MIT-licensed core
Pricing, plan by plan
Fig
FreeNo published plan breakdown. See the Fig review.
Lightdash
Free- Open SourceFree
- MIT-licensed core
- Self-hostable
- dbt integration
- Cloud ManagedOn request
- Managed hosting
- Premium features
- AI agent capabilities
Which should you pick?
Choose Lightdash if
- You need dbt integration.
- You want to start without paying.
- You work on Web, Self-hosted.
- You also want metrics layer.
Questions people ask
- Is Fig or Lightdash better?
- Neither clearly leads. Fig starts at Free and Lightdash at Free, and user ratings are close enough to be indistinguishable. Choose on capability and platform support.
- Which is cheaper, Fig or Lightdash?
- Fig starts at Free and Lightdash at Free.
- Does Fig or Lightdash run on more platforms?
- Fig runs on Web. Lightdash runs on Web, Self-hosted.
- Can I use Fig for free?
- Both have a free tier, so you can try either at no cost before committing.
- What can Fig do that Lightdash cannot?
- Lightdash covers dbt Integration, Metrics Layer, Dashboards, Scheduling.
Answered from the vendors’ own pages
Lightdash: Is Lightdash free?
Yes. Lightdash is free and open source under the MIT license. Self-hosting is completely free. Managed cloud services and enterprise features require separate licensing.
SourceLightdash: How does Lightdash integrate with dbt?
Lightdash reads dbt models and metric definitions directly. A team defines metrics once in dbt and reuses them across dashboards, exploration, and AI agents without redefinition.
SourceLightdash: Does Lightdash support SQL queries?
Yes. As a modern BI platform for analysts, Lightdash supports full SQL capabilities alongside dbt model exploration and visual query builders.
SourceLightdash: What are Lightdash AI agents?
Lightdash AI agents, available on paid plans, allow natural language queries against your data, generating SQL and visualizations automatically from questions.
SourceLightdash: Can Lightdash be self-hosted?
Yes. Lightdash's MIT-licensed core is completely self-hostable and free. Enterprise features and AI agents ship under separate licensing.
SourceRelated pages
Other head to heads
- Fig vs Sweep
- Fig vs Cody
- Fig vs Warp
- Fig vs Visual Studio Code
- Fig vs CodeSandbox
- Fig vs GitLab
- Fig vs Keycloak
- Fig vs Vite
- Fig vs Daytona
- Fig vs Depot
- Fig vs ESLint
- Fig vs Helix
- Fig vs Refact
- Fig vs Restate
- Fig vs RubyMine
- Fig vs Soketi
- Fig vs SonarQube
- Fig vs Sourcegraph
- Fig vs Rill Data
- Fig vs PostHog
- Fig vs Zenlytic
- Fig vs Power BI
- Fig vs Klipfolio
- Fig vs Domo
- Fig vs ThoughtSpot
- Fig vs Grow
- Fig vs Exa
- Fig vs Holistics
- Fig vs Logi Analytics
- Fig vs Sisense
- Fig vs Deepnote
- Fig vs Evidence
- Fig vs Geckoboard
- Fig vs Google Data Studio
- Fig vs Mode
- Fig vs Oracle Analytics Cloud
- Lightdash vs Sweep
- Lightdash vs Cody
- Lightdash vs Warp
- Lightdash vs Visual Studio Code
- Lightdash vs CodeSandbox
- Lightdash vs GitLab
- Lightdash vs Keycloak
- Lightdash vs Vite
- Lightdash vs Daytona
- Lightdash vs Depot
- Lightdash vs ESLint
- Lightdash vs Helix
- Lightdash vs Refact
- Lightdash vs Restate
- Lightdash vs RubyMine
- Lightdash vs Soketi
- Lightdash vs SonarQube
- Lightdash vs Sourcegraph
- Lightdash vs Rill Data
- Lightdash vs PostHog
- Lightdash vs Zenlytic
- Lightdash vs Power BI
- Lightdash vs Klipfolio
- Lightdash vs Domo
- Lightdash vs ThoughtSpot
- Lightdash vs Grow
- Lightdash vs Exa
- Lightdash vs Holistics
- Lightdash vs Logi Analytics
- Lightdash vs Sisense
- Lightdash vs Deepnote
- Lightdash vs Evidence
- Lightdash vs Geckoboard
- Lightdash vs Google Data Studio
- Lightdash vs Mode
- Lightdash vs Oracle Analytics Cloud