Explore Results with iQ Insights
- Capella Columnar
- how-to
After you run a query, you can visualize its results with charts and graphs generated by AI.
iQ Insights lets you leverage the power of AI to generate charts and graphs based on your query results. Use Capella iQ for your queries and help with SQL++ syntax, and use iQ Insights to get better insights from the data in those query results.
| iQ Insights is available on all plans for Capella operational and Capella Columnar clusters. |
iQ Insights is available as part of Capella’s query editor and Capella Columnar’s workbench.
About iQ Insights
iQ Insights uses OpenAI to generate visualizations. It analyzes and extracts the structure of your document schema from the JSON datasets of query results to generate relevant bar charts, line graphs, scatter plots, or other more complex visualizations.
Before you can use Capella iQ or iQ Insights, an Organization Owner must accept the Supplemental Terms.
Once the terms and conditions are accepted, all users in an organization can use Capella iQ and iQ Insights in any Capella operational and Columnar clusters.
| By accepting the Supplemental Terms for Capella iQ, you also accept the terms for iQ Insights. |
Prerequisites
-
An organization owner has accepted the iQ Insights Supplemental Terms. For more information, see Privacy and Security.
-
You have deployed a Capella operational cluster or a Capella Columnar cluster. If you’re working with an operational cluster, it must have the Data Service deployed on at least 1 Service Group.
-
Your queries must:
-
Use a dataset with clear document fields and identical document schemas. iQ Insights will attempt to auto-infer your data, but needs meaningful data labels and uniform schemas to create charts.
-
Use SELECT statements only. SELECT statements can include WITH and LIMIT clauses. Queries with any other statements or clauses are not supported.
-
Generate result sets that are within the 6 MB sizing limit and contain more than 1 document.
-
| If iQ Insights is producing errors, review the prerequisites and make sure your query follows the iQ Insights query guidelines before trying again. |
Generate Visualizations with iQ Insights
When you run SQL++ queries, you can visualize the results with AI by selecting the iQ Insights tab in the query results pane and click Generate Now. This generates various graphs and charts of your query results.
You can export the charts in PNG format.
iQ Insights is available to use with all SELECT queries, including those generated by Capella iQ.
|
Capella iQ provides two options for visualizations:
|
Privacy and Security
iQ Insights has the same privacy and security terms as Capella iQ. By accepting the Supplemental Terms for Capella iQ, you also accept the terms for iQ Insights. For more information about using OpenAI based tools in Couchbase Capella, see Privacy and Security.
As a user of iQ Insights, Couchbase would like to remind you that you share a responsibility when using this tool. Users of iQ Insights must keep the following in mind:
-
Do not generate a chart using confidential query results, such as personally identifiable information or any confidential information you would not want shared with a third party. See Privacy and Security for more information.
-
Verify the output of iQ Insights before using it. iQ Insights results are a visualization aid. LLMs can experience hallucinations and provide incorrect information from time to time.
-
Respect the use policies set out in the Couchbase Capella iQ Supplemental Terms.