Availability: Deep research is a Beta feature available on Enterprise plans. It is gated by the
ai-deep-research feature flag (the same flag used by the Deep Research API). Contact Lightdash to enable it for your organization.When to use it
Reach for deep research when the question is worth a report, not a reply:- βWhich product categories are trending down this quarter, and why?β
- βWhatβs driving the drop in returning-customer revenue over the last 90 days?β
- βCompare paid-vs-organic acquisition quality across our top three regions.β
Turning it on in the composer
The agent composer has an inline Deep research switch next to the message input. Ask is the default and behaves exactly as documented in Using AI agents β turning deep research on does not change normal Ask behavior. Deep research is available only on new agent conversations. To start one, open the agent and click New thread, then toggle Deep research before you send your first message.Preflight and depth tiers
When deep research is on, a preflight panel appears above the composer. It lets you pick the research depth and shows which evidence sources the agent will search. Depths map to the same effort budgets used by the Deep Research API:
Duration and query counts are ceilings β many runs finish sooner. Warehouse-query allowances count executed queries against your projectβs semantic layer or SQL, so heavier tiers do more validation and consider more alternative explanations.
The preflight also lists the evidence sources the current service supports (for example, project data and the public web). Sources that arenβt wired up for your deployment are hidden, so you always see the actual research surface for your workspace.
The run card
Submitting a deep research question registers a durable run card in the thread immediately. Your question is never lost, even if the network hiccups or you close the tab. The card walks through these states:- Queued β the run has been accepted and is waiting to start.
- Running β the agent is planning, gathering evidence, and validating findings. The card shows the current phase (planning, gathering context, testing explanations, reviewing evidence, writing the report) and the last few progress events.
- Complete β the report is ready. The card expands into the report view.
- Partially complete β the run hit a limit or a soft failure but produced a usable report from the evidence it did gather.
- Cancelled β you (or someone else on your team) stopped the run. The card shows sanitized recovery copy so you can retry with a new question.
- Failed β the run couldnβt finish. The card explains what to try next without leaking internal errors.
Cancelling a run
While a run is queued or running, the card exposes a Cancel action. Cancellation is best-effort and asynchronous β the card moves to a βcancellation requestedβ state, then to Cancelled once the backend confirms.Report view
A completed (or partially complete) run expands into a single linear report inside the agent workspace. The agent authors the report as one markdown document, so prose, findings, callouts, and charts appear together in the order the agent chose β rather than being split into fixed panels. A typical report includes:- An intro framing the question and the scope of the investigation.
- One or more finding sections, each with a heading and a confidence badge (
low/medium/high) that may carry a short inline caveat. - Callouts for important context β notes, tips, information, and warnings β inline with the prose that references them.
- A conclusion with the headline answer and bullet-pointed next steps or unresolved questions.
low.
Charts inline with the narrative
Findings that need a chart embed it directly in the report where the prose calls it out β at most one chart per finding, so the surrounding text is always the narrative that explains it. Each chart is a snapshot taken when the report was published, so opening the report months later shows exactly the numbers the agent saw. The chart tile is labelled with the snapshot date, and every chart has a View live data toggle that re-executes the underlying query against your warehouse for a fresh view.- Warehouse charts come from a semantic-layer query the agent ran during the investigation. They show read-only applied-filter pills so you can see how the data was scoped, and support the live-data refresh.
- Agent-computed charts carry an Agent-computed badge. Their values are derived from analysis the agent performed during the run (for example, aggregations over data pulled from documents or the web) rather than from a single warehouse query, so the live-data refresh does not apply.
Follow-up actions
From a completed run card, you can:- Challenge β push the agent to reconsider a finding you think is wrong.
- Rerun deeper β resubmit the same question at a higher depth tier.
- Share β send a link to the thread so a teammate can read the report.
- View activity β inspect the ordered timeline of what the agent did during the run.
- Cancel β available while a run is still in progress.