Skip to main content

data_vector_indexes

Operations on a data_vector_indexes resource.

Overview

Namedata_vector_indexes
TypeResource
Iddatabricks_workspace.vectorsearch.data_vector_indexes

SELECT not supported for this resource, see the methods section for supported operations.

Methods

NameAccessible byRequired ParamsDescription
deletedatavectorindexDELETEindex_name, deployment_nameHandles the deletion of data from a specified vector index.
upsertdatavectorindexREPLACEindex_name, deployment_nameHandles the upserting of data into a specified vector index.

REPLACE example

Replaces a data_vector_indexes resource.

/*+ update */
-- replace field1, field2, etc. with the fields you want to update
REPLACE databricks_workspace.vectorsearch.data_vector_indexes
SET field1 = '{ value1 }',
field2 = '{ value2 }', ...
WHERE index_name = '{{ index_name }}' AND
deployment_name = '{{ deployment_name }}';

DELETE example

Deletes a data_vector_indexes resource.

/*+ delete */
DELETE FROM databricks_workspace.vectorsearch.data_vector_indexes
WHERE index_name = '{{ index_name }}' AND
deployment_name = '{{ deployment_name }}';