Lightdash

It is an open-source business intelligence platform that connects to dbt to define metrics once and provide consistent reporting, dashboards, and AI-assisted analysis on warehouse data. It sells to data teams, analytics engineers and business users in B2B organizations that use modern data stacks. It is positioned as an AI-first alternative to per-seat BI tools with a native dbt semantic layer and open-source foundation, delivered as self-hosted open source or hosted cloud with enterprise options.

Key features

• Data explorer and report builder UI
• Native dbt integration and semantic layer
• Scheduled reports and alerting
• SQL runner
• Google Sheets sync
• Private spaces
• Global search
• Version history
• Usage analytics and insights
• API and webhooks
• Smart caching and pre-aggregates
• AI agents and MCP Autopilot
• Self-improving semantic layer
• Embedding via iframe and React SDK
• Git sync with Github GitLab Azure Bitbucket
• Slack and Teams integrations
• CSV export
• SSO SAML SCIM user management
• Warehouse support BigQuery Snowflake Redshift Databricks Postgres Trino ClickHouse Athena DuckDB