back_office_ops · ecommerce · workflow
Loblaw Digital leverages LLMs to auto-generate dbt documentation across 3,000+ models
With thousands of dbt models across different lines of business, documentation was a manual, slow, and error-prone process that was frequently omitted, leading to 'documentation debt' and confusion for business users unfamiliar with the data.
How it works
Common implementation structure
How this type of workflow is generally built, generalized across documented cases — not tied to any one vendor's stack. Click any stage to read what happens there. Specific products that implement these stages appear in “Tools commonly seen” below.
Stage 1 · dbt model compiled to JSON
When dbt compiles a model, it transforms the model into JSON format.
Tools used
dbtdbt documentorVertex AILLMs
Outcome
Automated dbt documentation generation using LLMs via dbt documentor increased productivity for analytics engineers, covering over 3,000 live models across dev, data, and business analytics teams at Loblaw.
Results
Volumeover 3,000 models
Grounding & classification
Source type: technical build writeup
18 fields verified against source quotes.
content generationknowledge basenamed customerproduction runtime claimedtools describedworkflow describedretailemployee productivitytime savedtechnical build writeupback office opsdocument to record