Good prompting
- Try to think better what do you want. âTell me if this is successfulâ is an awful question. Solve that first. The answer to that: Lean Analytics.
- Provide data context: https://cloud.google.com/blog/products/databases/techniques-for-improving-text-to-sql
For example, even the best DBA in the world would not be able to write an accurate query to track shoe sales if they didnât know that cat_id2 = âFootwearâ in a pcat_extension table means that the product in question is a kind of shoe. The same is true for LLMs
Improvements we can make
- Are our dbt docs accessible to people?
- Can we store preferences of the user to disambiguate terms?
- Metrics frameworks