dbt
Answers that pick the right model and match your metric definitions.
01
Dot learns your dbt project
Model docs, SQL and lineage.
Daniel Weber9:41 AM
@Dot Where does revenue in fct_orders come from, and does it include refunds?
1 reply
Dot9:42 AM
From stg_stripe__charges through int_payments, net of refunds. Stripe and Shopify are its sources.
Source: dbt’s fct_orders.
Here is the data.
| Step | Model |
|---|---|
| Sources | stripe, shopify |
| Staging | stg_stripe__charges |
| Intermediate | int_payments |
Today
Daniel Weber9:41 AM
Dot Where does revenue in fct_orders come from, and does it include refunds?
Dot9:42 AM
From stg_stripe__charges through int_payments, net of refunds. Stripe and Shopify are its sources.
Source: dbt’s fct_orders.
- Sources: stripe, shopify
- Staging: stg_stripe__charges
- Intermediate: int_payments
Lisa Park9:41 AM
@Dot Does our MRR model spread annual plans over 12 months? What was September MRR?
1 reply
Dot9:42 AM
Yes, mrr_monthly spreads them evenly. September MRR was $412K, up 4% on August.
Source: dbt’s mrr_monthly.
Today
Lisa Park9:41 AM
Dot Does our MRR model spread annual plans over 12 months? What was September MRR?
Dot9:42 AM
Yes, mrr_monthly spreads them evenly. September MRR was $412K, up 4% on August.
Source: dbt’s mrr_monthly.
David Mensah9:41 AM
@Dot Which model should I use for marketing attribution, and how does it credit touches?
1 reply
Dot9:42 AM
Use fct_attribution. It gives first and last touch 40% each and splits the rest.
Source: dbt’s fct_attribution.
Today
David Mensah9:41 AM
Dot Which model should I use for marketing attribution, and how does it credit touches?
Dot9:42 AM
Use fct_attribution. It gives first and last touch 40% each and splits the rest.
Source: dbt’s fct_attribution.
02
Dot answers with dbt metrics
Queried through the dbt Cloud Semantic Layer.
Lisa Park9:41 AM
@Dot What was the average contract value of new deals by quarter this year?
1 reply
Dot9:42 AM
$22.6K in Q3, up 24% since Q1, led by Enterprise.
Source: dbt’s average_contract_value.
Today
Lisa Park9:41 AM
Dot What was the average contract value of new deals by quarter this year?
Dot9:42 AM
$22.6K in Q3, up 24% since Q1, led by Enterprise.
Source: dbt’s average_contract_value.
David Mensah9:41 AM
@Dot Show weekly signups by acquisition channel since January.
1 reply
Dot9:42 AM
Organic leads with 4,820 signups. Paid search is up 22% since March.
Source: dbt’s signups.
Today
David Mensah9:41 AM
Dot Show weekly signups by acquisition channel since January.
Dot9:42 AM
Organic leads with 4,820 signups. Paid search is up 22% since March.
Source: dbt’s signups.
Sarah Chen9:41 AM
@Dot Which product modules are behind their ARR target?
1 reply
Dot9:42 AM
Analytics is 8% behind target at $2.1M. The other three modules are on track.
Source: dbt’s arr.
Here is the data.
| Module | ARR | Of target |
|---|---|---|
| Analytics | $2.1M | 92% |
| Billing | $3.4M | 101% |
| Payroll | $2.8M | 104% |
Today
Sarah Chen9:41 AM
Dot Which product modules are behind their ARR target?
Dot9:42 AM
Analytics is 8% behind target at $2.1M. The other three modules are on track.
Source: dbt’s arr.
- Analytics: $2.1M ARR, 92% of target
- Billing: $3.4M ARR, 101% of target
- Payroll: $2.8M ARR, 104% of target
How GetDot works with dbt
How Dot reads your dbt project
Dot clones the repo, parses the project and matches each model to its table in your warehouse. Model and column descriptions, the SQL and the lineage back to the sources land on those tables, so Dot picks the right model, and answer lineage traces a number from source tables through dbt models to the answer.
dbt Semantic Layer (MetricFlow)
With dbt Cloud’s Semantic Layer, connect an environment ID and a service token. Dot reads every metric with its dimensions and entities and treats each metric as its own table, so a question maps straight to the metric that answers it. MetricFlow writes the SQL, so your definitions decide the numbers.
Dot and dbt’s own AI
As of October 2026, dbt Labs offers the dbt MCP server, which gives any MCP client your project’s metadata and Semantic Layer tools (metrics, dimensions, entities, metric queries) plus SQL tools; its text_to_sql tool draws on your dbt Copilot allotment. Semantic Layer and Discovery API access depends on your dbt plan.
It is built for analytics engineers who want dbt context in their own editor. Dot is for the people who will never open that editor: they ask in Slack, Teams or email and get answers built on your dbt docs, with or without dbt Cloud.
Questions
More in Semantic layers
Connect your data.
Start for Free
Malloy
Power BI
Cube