⚡ TL;DR Add the Semantic Layer host, environment ID and a service token from dbt Cloud. Read-only, one environment per connection.
One definition of revenue, everywhere it shows up.
🔌 What It Does
Queries governed dbt metrics, sliced by dimensions and time, without warehouse SQL.
⚙️ Setting It Up
Copy the host, environment ID and service token from dbt Cloud and add them under Connectors; Lovable validates them.
💡 What You Can Build
A few ideas:
- ✅ KPI dashboards
- ✅ Embedded customer analytics
- ✅ Metric explorers
- ✅ Team scorecards
⚠️ Limits
Read-only, needs dbt Cloud with the Semantic Layer (not Core alone), and one environment and shared token per connection.
💡 Pro tip Use governed metrics so every dashboard matches the official numbers.
Need governed metrics in an app? Lord of the Wix can help. ✨
❓ Lovable dbt Semantic Layer integration FAQ
Does dbt Core work?
No, dbt Cloud is required.
Is it read-only?
Yes.
How many environments per connection?
One.
Which credentials are needed?
Host, environment ID and service token.
Do I need to write SQL?
No.
🙏 Credit: Based on public information from the Lovable documentation. Lovable is a product of Lovable. Source: docs.lovable.dev. Lord of the Wix is an independent agency and is not affiliated with Lovable.