HeavyIQ Overview

HeavyIQ leverages the power of a custom-trained Large Language Model (LLM) to allow you to ask questions of your data using natural language.

HeavyIQ works seamlessly with the broader HEAVY.AI platform to make asking questions of data instant, powerful, and effortless

What is it?

HeavyIQ is a new capability in the HEAVY.AI platform that allows users to use natural language to ask questions of and interact with their data. At the core of HeavyIQ is HeavyLM, a powerful Large Language Model (LLM) that has been custom fine-tuned on over 60,000 instruction pairs to deliver state-of-the-art performance for text-to-sql, natural language summarization, and other data analytics tasks such as sentiment analysis, named entity extraction, and classification. Since HeavyIQ is built around a custom model, it does not require online access to third-party LLM providers, ensuring complete data privacy and even allowing for fully air-gapped, offline deployment if desired.

In addition to the custom HeavyLM model, support for HeavyIQ is deeply integrated into both the HeavyDB database and Heavy Immerse visual analytics platform.

In HeavyDB, users can use the new LLM_TRANSFORM operator to call the HeavyLM model inline from SQL for a wide variety of use cases, whether ELT (Extract Transform Load) tasks like date value cleanup, or core analytics workflows like sentiment analysis or classification. The HeavyLM model is specifically trained to deliver terse responses suitable for downstream analytics, and the LLM_TRANSFORM operator allows optional constraint of the LLM output to a regex or a set of output values to ensure the results of the operator can be reliably used downstream.

From Heavy Immerse, users can work directly within the new SQL notebook to ask questions of their data in natural language, getting back SQL, and if desired, the raw or natural-language summarized results and compelling auto-generated visualizations. Unlike other text-to-SQL platforms, all relevant metadata, including top values, column ranges, table and column metadata, and with 8.1, user-provided guidance is automatically and intelligently fed into the prompts sent to the HeavyLM model to provide the model with the necessary context to deliver the most accurate answers.

An example of HeavyIQ-generated SQL and visualizations in our new Heavy Immerse SQL notebook.

How to Try it?

Learn more about HeavyIQ and try our interactive demos live here. HeavyIQ (using a publicly hosted model) is also available to all Free Edition users, and can be deployed privately behind your organization's firewall as part of an Enterprise deployment.

HeavyIQ SQL NotebookHeavyIQ GuidanceHeavyIQ LLM_TRANSFORM