Blog OpenAI Integration with Knowi

OpenAI Integration with Knowi

OpenAI Integration with Knowi

Knowi is always looking to bring innovative features to its users, with the latest one being its integration with OpenAI. This has unlocked doors for:

I. Creating a dataset with OpenAI as a datasource and developing visualizations on top of it, and
II. Conducting data exploration and generating queries using plain English statements.

In this blog post, we will cover the following: 

Let’s get started 🚀 

What is OpenAI?

OpenAI is a non-profit research organization that aims to develop and direct artificial intelligence. 

The mission is to ensure that artificial general intelligence (AGI)—by which the company means highly autonomous systems that outperform humans at most economically valuable work—benefits all of humanity.

The organization is dedicated to conducting fundamental research in AI, building cutting-edge AI technologies, and advocating for safe and ethical AI practices.

Knowi’s OpenAI Datasource Integration 

Knowi provides the option to create a dataset with OpenAI as a datasource and develop visualizations on top of it.

Before you can create your dashboard with OpenAI, you need to add OpenAI as a data source and query against it.

For more information, you can follow OpenAI datasource documentation. 

Knowi’s AI Query Generator

The AI query generator from Knowi automatically generates queries from plain English statements, searches the connected databases, and retrieves the data requested. 

The goal for this integration involves simplifying and speeding up the search process by automatically generating relevant and specific queries and improving the probability of finding the requested information.

The following example displays a MongoDB query being generated within Knowi using plain English statements. In the illustration below, you can observe how the MongoDB database is being queried to- 

“Return spam rate, spam, and sent from the sendingActivity collection, grouped by customer. Spam rate is calculated as (spam/sent)*1000000”

The AI Query generator has been integrated with multiple datasources including, but not limited to, Snowflake, ElasticSearch, MySQL, Couchbase, PostgreSQL, and more. 


Knowi implemented the OpenAI integration to help data engineers, data analysts, data scientists, or anyone responsible for managing the data to make querying easier while increasing overall productivity. Further more, OpenAI as a datasource within Knowi allows you to enrich the existing data with OpenAI, whether it be in your query workflow or dashboards.

Want to see how Knowi can help?

Sign up here for a 15-minute demo where we will learn more about your use case and recommend a few features that may be a good fit for what you're trying to accomplish.

Share This Post

Share on facebook
Share on linkedin
Share on twitter
Share on email
About the Author: