4.2.1 Requirements

This section lists various requirements for using HeatWave GenAI.

DB System Requirements

• To use HeatWave GenAI, you require a HeatWave database system.

  The database system must meet the following requirements:

  • The HeatWave database system must be version 9.0.0 - Innovation or higher.

  • A HeatWave Cluster must be added to your database system. The shape of the cluster must be HeatWave.512GB.

  • HeatWave Lakehouse must be enabled on the database system.

  For more information, see Creating a DB System, Editing a DB System, and Connecting to the DB System.

Required Resources

• To create a vector store, you need an Oracle Cloud Infrastructure (OCI) Object Storage bucket for storing files that you want the vector store to ingest.

• Vector store can ingest files in the following formats: PPT, TXT, HTML, DOC, and PDF. Each file can be upto 100 MB in size.

Required Privileges

To perform the following HeatWave GenAI functions, ask the admin user to grant you the required privileges:

• To create a vector store using asynchronous load, the VECTOR_STORE_LOAD_EXEC privilege is required:

  Press CTRL+C to copy
   
  mysql> GRANT VECTOR_STORE_LOAD_EXEC TO 'user_name'@'%';

• To run the batch queries using ML_GENERATE_TABLE, ML_RAG_TABLE, and ML_EMBED_TABLE, the following privileges are required:

  • SELECT and ALTER privileges on the input table:

    Press CTRL+C to copy
     
    mysql> GRANT SELECT, ALTER ON input_schema.input_table TO 'user_name'@'%';

  • SELECT, INSERT, CREATE, DROP, ALTER, UPDATE privileges on the schema where the output table is created.

    Press CTRL+C to copy
     
    mysql> GRANT SELECT, INSERT, CREATE, DROP, ALTER, UPDATE ON output_schema.* TO 'user_name'@'%';

For more information, see Privileges Provided by MySQL and Default MySQL Privileges.