Use the Insert Data tab in the OpenSearch Vector Search Edition console to manually insert individual records into an instance table.
Prerequisites
Before you begin, make sure you have:
An OpenSearch Vector Search Edition instance with at least one table configured
The table schema created with the appropriate field types for your data
Open the Insert Data tab
Log on to the OpenSearch Vector Search Edition console.
In the left-side navigation pane, click Instances.
On the Instances page, find the target instance and click its ID.
In the left-side pane of the instance details page, choose Vector Management > Insert Data.
On the Insert Data tab, select the target table from the dropdown.
Insert a record
The Insert Data tab supports two input modes: form mode (default) and developer mode. Both modes support the same four data types.
Required fields by data type
| Data type | Required fields |
|---|---|
| Vector data | Primary key fields, dense vector fields |
| Combined query data | Primary key fields, dense vector fields, sparse index fields, sparse vector fields |
| Text data for embedding | Primary key fields, text fields that require embedding |
| Image data for embedding | Primary key fields, image fields that require embedding |
For image data, you can either upload an image file directly or enter the base64-encoded string of the image.
Use form mode
Fill in the required fields for your data type and click Add.
Use developer mode
Developer mode lets you enter data as a structured payload instead of using individual form fields.
In the upper-right corner of the Insert Data tab, select Developer Mode.
Enter a payload with the required fields for your data type.
Click Add.
Verify the insertion
After clicking Add, check the Results section. A successful insertion returns:
"message": "success"After a successful insertion, go to the Query Test page to run queries against the data.
Limitations
| Data type | Size limit |
|---|---|
| Each data record | Up to 1 MB |
| Text data for embedding | Up to 1 MB |
| Image data for embedding | No upper limit (can exceed 1 MB) |