Your warehouse
- Amazon Redshift
- BigQuery
- ClickHouse
- Databricks
- MotherDuck
- PostgreSQL
- Snowflake
- Trino
Source of truth
Platform
Lightdash Context Layer
Semantics
Metrics · joins
Context
Business logic · internal docs
Caching
Fast · consistent results
Permissions
Authentication
Activation
Consumption layer
Agents
Governed autonomous AI
Apps
Data Products · Workflows
Dashboards
Interactive · drill-down
SDKs
Python · JS · API
Embedding
Customer-facing analytics
MCP
Internal / external
Evaluation
Feedback loop
Autopilot
Scheduled health, zero effort
Self-improving SL
Metrics that never drift
Caching
S3 · Pre Aggs
Context
.md · .files
Permissions
RLS · Auth · SSO
Sends to context layer
Continuously refined