By integrating ChatGPT, a language model developed by OpenAI, with Omniscope Evo, users can leverage natural language processing capabilities to generate custom SQL queries within the database block. This enables users to ask questions in a more intuitive and natural way, making data analysis and exploration more accessible and efficient.
The integration process is fairly simple:
- Ensure you have Omniscope installed and have access to a supported database.
- Access OpenAI API: Obtain an API key from OpenAI by following their documentation (see https://platform.openai.com/ ). This API key will allow you to interact with the ChatGPT model.
- Enter the API key into the Omniscope's Admin > AI Integration section, as per image.
- Now integrate ChatGPT into Omniscope: Open Omniscope and navigate to the database block.
Pick the Custom SQL option and enter the question in the Auto-generate box e.g. "what are the top ten regions by rainfall". ChatGPT will translate the question into a Custom SQL statement, including JOIN operation, if needed, to combine multiple tables and retrieve the data needed to answer the question (see image below)
The application - see below the Options tab and how you can ask a question in the auto-generate section.