Insert data from tables
Insert vector data
Log on to the OpenSearch Vector Search Edition console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click its ID to go to the instance details page. In the left-side pane of the instance details page, choose Vector Management > Insert Data. On the Insert Data tab, select a table to insert data.
Enter values for the fields, including the fields whose data is primary keys and dense vectors. Then, click Add.
If "message": "success" appears in the Results section, the data is uploaded.
After the data is uploaded, you can perform queries on the Query Test page.
Insert data for combined queries
Log on to the OpenSearch Vector Search Edition console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click its ID to go to the instance details page. In the left-side pane of the instance details page, choose Vector Management > Insert Data. On the Insert Data tab, select a table to insert data.
Enter values for the fields, including the fields whose data is primary keys, dense vectors, sparse indices, and sparse vectors. Then, click Add.
If "message": "success" appears in the Results section, the data is uploaded.
After the data is uploaded, you can perform queries on the Query Test page.
Insert text data for embedding
Log on to the OpenSearch Vector Search Edition console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click its ID to go to the instance details page. In the left-side pane of the instance details page, choose Vector Management > Insert Data. On the Insert Data tab, select a table to insert data.
Enter values for the fields, including the fields whose data is primary keys and data that requires text embedding. Then, click Add.
If "message": "success" appears in the Results section, the data is uploaded.
After the data is uploaded, you can perform queries on the Query Test page.
Insert image data for embedding
Log on to the OpenSearch Vector Search Edition console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click its ID to go to the instance details page. In the left-side pane of the instance details page, choose Vector Management > Insert Data. On the Insert Data tab, select a table to insert data.
Enter values for the fields, including the fields whose data is primary keys and data that requires image embedding. You can upload an image or enter the base64-encoded string of an image. Then, click Add.
If "message": "success" appears in the Results section, the data is uploaded.
After the data is uploaded, you can perform queries on the Query Test page.
Insert data in developer mode
Insert vector data
Log on to the OpenSearch Vector Search Edition console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click its ID to go to the instance details page. In the left-side pane of the instance details page, choose Vector Management > Insert Data. On the Insert Data tab, select a table to insert data.
In the upper-right corner of the Insert Data tab, select Developer Mode. Enter values for the fields, including the fields whose data is primary keys and dense vectors. Then, click Add.
If "message": "success" appears in the Results section, the data is uploaded.
After the data is uploaded, you can perform queries on the Query Test page.
Insert data for combined queries
Log on to the OpenSearch Vector Search Edition console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click its ID to go to the instance details page. In the left-side pane of the instance details page, choose Vector Management > Insert Data. On the Insert Data tab, select a table to insert data.
In the upper-right corner of the Insert Data tab, select Developer Mode. Enter values for the fields, including the fields whose data is primary keys, dense vectors, sparse indices, and sparse vectors. Then, click Add.
If "message": "success" appears in the Results section, the data is uploaded.
After the data is uploaded, you can perform queries on the Query Test page.
Insert text data for embedding
Log on to the OpenSearch Vector Search Edition console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click its ID to go to the instance details page. In the left-side pane of the instance details page, choose Vector Management > Insert Data. On the Insert Data tab, select a table to insert data.
In the upper-right corner of the Insert Data tab, select Developer Mode. Enter values for the fields, including the fields whose data is primary keys and data that requires text embedding. Then, click Add.
If "message": "success" appears in the Results section, the data is uploaded.
After the data is uploaded, you can perform queries on the Query Test page.
Insert image data for embedding
Log on to the OpenSearch Vector Search Edition console. In the left-side navigation pane, click Instances. On the Instances page, find the instance that you want to manage and click its ID to go to the instance details page. In the left-side pane of the instance details page, choose Vector Management > Insert Data. On the Insert Data tab, select a table to insert data.
In the upper-right corner of the Insert Data tab, select Developer Mode. Enter values for the fields, including the fields whose data is primary keys and data that requires image embedding. You can upload an image or enter the base64-encoded string of an image. Then, click Add.
If "message": "success" appears in the Results section, the data is uploaded.
After the data is uploaded, you can perform queries on the Query Test page.
Usage notes
Each data record that you can insert can be up to 1 MB in size.
The image data that you can insert for embedding can exceed 1 MB in size.
The text data that you can insert for embedding can be up to 1 MB in size.