Inventory of transformation SQL outside version control
Before writing a single model, find where business logic already lives: scheduled warehouse queries, views nobody owns, custom SQL inside BI datasets and the spreadsheet that someone refreshes on Mondays. That list becomes the backlog for the dbt project and shows which numbers will move when logic is consolidated. In most teams it turns up two or three competing definitions of the same table.
First tasks
- Export the list of scheduled queries and views from the warehouse
- List every BI dataset that uses custom SQL instead of a table
- Mark each item keep, migrate or retire in one sheet
- Rank the ten most-read items by query count over the last 90 days