4.4.3 Updating a Vector Store

To keep up with the changes and updates in the documents in your , you must update the vector embeddings loaded in the vector store table on a regular basis. This ensures that the responses generated by HeatWave GenAI are up-to-date. And, it deletes the embeddings that are no longer useful.

You can update the vector store table using the following methods:

• Loading Data Incrementally into the Vector Store Table

• Deleting and Recreating the Vector Store Table

Before You Begin

• Complete the steps to set up a vector store.

Loading Data Incrementally into the Vector Store Table

Incremental load refreshes the vector embeddings for documents that have already been ingested into the vector store, and for the new documents that are available in the bucket, it creates and loads the vector embeddings into the vector store. For documents that have been deleted from the bucket, incremental load deletes the vector embeddings from the vector store.

Incremental loading for vector store tables is supported in MySQL 9.0.1-u1 and later versions.

To update the embeddings in the vector store table using incremental load, perform the following steps:

1. Check that the vector embeddings are loaded in the vector store table you want to update:

   Press CTRL+C to copy
    
   select count(*) from VectorStoreTableName;

   Replace VectorStoreTableName with the name of the vector store table you want to update.

   For example:

   Press CTRL+C to copy
    
   select count(*) from demo_embeddings;

   If you see a numerical value in the output, the embeddings are loaded in the table.

2. To specify vector store table to update, set the @dl_tables variable:

   Press CTRL+C to copy
    
   set @dl_tables = '[
     {
       "db_name": "DBName", 
       "tables": [
       {
         "table_name": "VectorStoreTableName"	
       }]
     }
   ]';

   Replace the following:

   • DBName: the name of database that contains the vector store table.

   • VectorStoreTableName: the vector store table name.

   For example:

   Press CTRL+C to copy
    
   set @dl_tables = '[
     {
       "db_name": "demo_db", 
       "tables": [
       {
         "table_name": "demo_embeddings"	
       }]
     }
   ]';

3. To enable incremental loading, set the refresh_external_tables parameter in the @options variable:

   Press CTRL+C to copy
    
   set @options = JSON_OBJECT("mode", "normal", "refresh_external_tables", true);

4. To load the new and updated vector embeddings into the vector store, use the HEATWAVE_LOAD routine:

   Press CTRL+C to copy
    
   call sys.HEATWAVE_LOAD(CAST(@dl_tables AS JSON), @options);

   This updates the vector store table with the new and updated embeddings.

5. Verify that the embeddings are updated in the vector store table:

   Press CTRL+C to copy
    
   select count(*) from VectorStoreTableName;

   For example:

   Press CTRL+C to copy
    
   select count(*) from demo_embeddings;

   If you see a numerical value in the output which is different than the one you saw in step 1, then the vector store table is successfully updated. In some cases, this value might not change even though the vector store table is successfully refreshed.

Deleting and Recreating the Vector Store Table

To delete and recreate the vector store table and vector embeddings, perform the following steps:

1. Delete the vector store table:

   Press CTRL+C to copy
    
   drop table VectorStoreTableName;

   Replace VectorStoreTableName with the vector store table name.

2. To create new embeddings for the updated documents, repeat the steps to set up a vector store.