Skip to main content

Process SQL Table Data into Knowledge Base

Once you have created a Knowledge Base, the next step is to import data into it. This section explains how to import and process SQL table files for structured data retrieval.

Steps to Process SQL Table Data Data​

1. Select the Knowledge Base​

Choose the Knowledge Base with the type Table-SQL to process SQL table files.

2. Import the Dataset​

  • Navigate to the dataset import section.
  • Select the dataset that contains the structured SQL table file.
  • You can only select a single file at a time for SQL table processing.

3. Select Columns and Define Data Types​

  • Choose the columns and assign appropriate data types:
    • Text
    • Date
    • Datetime
    • Varchar
    • Vector
    • JSON
  • Provide a description for each column to enhance data clarity.
  • Vector-indexed columns will undergo the vector indexing process, enabling searchability.
  • Filtered columns can be used for query filtering.

4. Confirm and Proceed​

Once the columns and data types are selected, click Confirm and Proceed to start the ingestion process.

5. Ingestion Process Status​

The ingestion process will go through the following stages:

  • In Queue: The dataset is waiting for processing.
  • Processing: The system is indexing and structuring the data.
  • Completed: The ingestion process is finished, and the data is ready for use.

Post-Ingestion Actions​

After the data ingestion is completed, users can:

  • Perform data retrieval testing to validate the dataset.
  • Directly use the Knowledge Base in the SimplAI Studio for further AI-powered applications.