Good prompting

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?