Linking Verodat to ChatGPT enables users to 'talk to the data', and ask questions in natural language to analyse the performance of their business. This helps you you analyze large and complex datasets quickly, easily and securely.
​
The solution is configured with the Verodat API, which collects, prepares, and adds context to your data. This means Verodat has trained the ChatGPT AI on key information about the data model, which enables the GPT to interpret queries input by the user, and apply it's understanding of the data model to create and execute a query against the database to deliver the answer.

Verodat is used to manage the supply of data to ChatGPT and enable it to answer key business questions for users.

The Verodat supplies the GPT with all the knowledge it requires to effectively craft queries from natural language questions and run these queries against the data in storage, including:

The Verodat platform also provides full provenance on all records it has processed ensuring that any record of data being used by the GPT can be fully attributed back to the source supplier along with an audit trail of all data management activities that have been completed.

AI solutions build using Verodat allow users to create 'Approved Queries' which are controlled by the Verodat platform to deliver accurate answers.
​
Users can ask any questions about data they have connected to GPT and the GPT will provide either an approved or an unapproved answer.

Approved answers have been given a defined 'approach' from a user to ensure the answer given is correct, and trustworthy.

Unapproved answers occur when the AI has interpreted the answer from it's context. As the AI has full context of the business model and the database in which the data is stored it can create a SQL query for the question being asked.

How do I know which query option has been used?

If you find a query helpful, you can add it to your AI Context in Verodat, allowing the GPT to learn and reuse it for future queries. This makes data analysis intuitive and efficient, leveraging Verodat's powerful data supply chain platform.

Verodat stores data model information, supply status information and manages data processing and its associated logging. It does not store the clients data.

Verodat moves data from the supplying source into a consolidated dataset stored in a clients database. This data is the clients data and is managed and maintained by the client.

Verodat configured GPTs are built in private mode. In this mode, the GPT creates queries and these details are returned to the end user in the conversation. As the conversation is not shared with Open AI then these details are private to the end user.

In a standard private deployment of the GPT, user access to this GPT and to the Verodat platform are governed using the Verodat access control model ensuring users only have access to the data they are required to access.

With the Verodat API, this GPT can turn your natural language questions into precise SQL queries, execute them on the Verodat database, and return the results for you to review. Meaning your raw data stays secure in your database, while you get the insights you need.

The Verodat API ensures that only the data you want ChatGPT to query is available to it.

This ensures the privacy and security of the activities of the end user in using the Verodat powered GPT. For more details on how to design and secured your AI implementation please checkout verodat.com and our slack community.

The Northwind Demo is a public example of a ChatGPT solution based on data from Verodat. You can use it to experience how GPT can be used to talk to data using an example database.

It's designed to give an example of the user experience ChatGPT offers for data analytics, and to showcase how Verodat supports secure, governed data querying using AI enabled tools.

Northwind is a sample database that was originally created by Microsoft and used as the basis for their tutorials in a variety of database products for decades. The sample data contains the sales data for Northwind Traders, a fictitious specialty foods export/import company.

The Northwind demo is publically available for testing here.

This is the list of approved queries: