One of the challenge when we have a database that has multiple tables that is not related in the normal sense but different key names within them join together. Exposing this knowledge to LLM require either have a 360 degree view of the data by joining them all together and creating one fact table of programming them through prompt engineering by providing LLM the knowledge of how the tables are connected. Below is the sample code that I’ve used to tackle this challenge.