MySQL :: HeatWave User Guide :: 4.2.3 Quickstart: Setting Up a Help Chat

HeatWave User Guide / ... / Quickstart: Setting Up a Help Chat

4.2.3 Quickstart: Setting Up a Help Chat

This quickstart shows how to use the vector store functionality and use HeatWave Chat to create a GenAI-powered Help chat that refers to the HeatWave user guide to respond to HeatWave related queries.

Note

This quickstart assumes that you are familiar with HeatWave Database Systems.

This quickstart contains the following sections:

Before You Begin

Review the Requirements.

To run this quickstart, you need HeatWave Database System version 9.0.0 - Innovation or higher. For more information, see Creating a DB System and Editing a DB System.
If not already done, add a HeatWave Cluster to your database system.
If not already done, enable HeatWave Lakehouse on the database system.
Enable the database system to access an OCI Object Storage bucket. For more information, see Resource Principals.

Setting Up the Object Storage Bucket

Download the HeatWave user guide PDF (A4) - 1.7Mb.
Create an Object Storage Bucket with the name quickstart_bucket.
Upload the PDF file to the Object Storage Bucket using the prefix quickstart/ to create a new folder by the name quickstart.

Connecting to the Database System

Connect to your HeatWave Database System.

Ensure that you pass the --sqlc flag while connecting to the database to use the classic MySQL protocol:
```
mysqlsh -uAdmin -pPassword -hPrivateIP --sqlc
```
Replace the following:
- Admin: the database system admin name.
- Password: the database system password.
- PrivateIP: the private IP address of the database system.

Setting Up the Vector Store

Create and use a new database:

create database quickstart_db;
use quickstart_db;

To create a schema to be used for task management, run the following command:
```
select mysql_task_management_ensure_schema();
```
Create the vector table and load the source document:
```
call sys.VECTOR_STORE_LOAD('oci://quickstart_bucket@Namespace/quickstart/heatwave-en.a4.pdf', '{"table_name": "quickstart_embeddings"}');
```
Replace Namespace with the name of the Object Storage bucket namespace that you are using.

This creates an asynchronous task in the background which loads the vector embeddings into the specified vector store table quickstart_embeddings.

The routine output that is displayed contains a query with the task ID.

To track the progress of the task, run the task query displayed on the screen:

select id, name, message, progress, status, scheduled_time,estimated_completion_time, estimated_remaining_time, progress_bar FROM mysql_task_management.task_status WHERE id=TaskID\G

Replace TaskID with the displayed task ID.

The output looks similar to the following:

                        id: 1
                      name: Vector Store Loader
                  message: Task starting.
                  progress: 0
                    status: RUNNING
            scheduled_time: 2024-07-02 14:42:38
estimated_completion_time: 2024-07-22 10:19:53
  estimated_remaining_time: 52.50000
              progress_bar: __________

After the task status has changed to Completed, verify that embeddings are loaded in the vector store table:
```
select count(*) from quickstart_embeddings;
```
If you see a numerical value in the output, your embeddings are successfully loaded in the vector store table.

Starting a Chat Session

Clear the previous chat history and states:
```
set @chat_options=NULL;
```

Ask your question using HeatWave Chat:

call sys.HEATWAVE_CHAT("What is HeatWave AutoML?");

The HEATWAVE_CHAT routine automatically loads the LLM and runs a semantic search on the available vector stores and retrieves context, by default. The output is similar to the following:

|  HeatWave AutoML is a feature of MySQL HeatWave that makes it easy to use
machine learning, whether you are a novice user or an experienced ML practitioner.
It analyzes the characteristics of the data and creates an optimized machine
learning model that can be used to generate predictions and explanations. The
data and models never leave MySQL HeatWave, saving time and effort while keeping
the data and models secure. HeatWave AutoML is optimized for HeatWave shapes and
scaling, and all processing is performed on the HeatWave Cluster. |

Ask a follow-up question:

call sys.HEATWAVE_CHAT("How to set it up?");

The output is similar to the following:

|  To set up HeatWave AutoML in MySQL HeatWave, you need to follow these steps:

1. Ensure that you have an operational MySQL DB System and are able to
connect to it using a MySQL client. If not, complete the steps described
in Getting Started with MySQL HeatWave.
2. Ensure that your MySQL DB System has an operational HeatWave Cluster.
If not, complete the steps described in Adding a HeatWave Cluster.
3. Obtain the MySQL user privileges described in Section 3.2, Before You Begin.
4. Prepare and load training and test data. See Section 3.4, Preparing Data.
5. Train a machine learning model. See Section 3.5, Training a Model.
6. Make predictions using the trained model. See Section 3.6, Making Predictions.
7. Generate explanations for the predictions made by the model. See Section 
3.7, Generating Explanations.
8. Monitor and manage the performance of the model. See Section 3.8,
Monitoring and Managing Performance. |

You can continue asking follow-up questions in the same chat session.

Cleaning Up

To avoid being billed for the resources that you created for this quickstart, perform the following steps:

Delete the database that you created:
```
drop database quickstart_db;
```
If you created a new database system, then delete the database system. For more information, see Deleting a DB System.
Delete quickstart_bucket. For more information, see Deleting the Object Storage Bucket.

PREV HOME UP NEXT