Lets jump right in with an actual question I just gave to a Hana Cloud Database:
The response I got back was correct :
Ok so you’re guessing I used ChatGPT, so it’s either hallucinating and made a lucky guess, or perhaps I pre-loaded the data (context) into ChatGPT and it just summarised the results for me.
I utilsed OpenAI’s API’s to converted the question into SQL, the SQL was then executed on a Hana Cloud instance and the results were then further summarised by OpenAI. LangChain’s SQLDatabaseChain does most of the work.
Heres the full interaction:
Bonus Points to anyone who noticed I ‘deliberately’ miss-spelt Australia in the question. It wasn’t a significant obstacle for OpenAI.
The SQL generated really does run in Hana:
The data flow is approximately like this:
The sample code is here:
The main inspirations and references include:
So as you can see it’s now possible to ask Hana questions in Natural language.
I hope you found this glimpse of a potential future interesting.
What use case would you find this useful for?