Skip to main content

vector_store_file_batches

Creates, updates, deletes, gets or lists a vector_store_file_batches resource.

Overview

Namevector_store_file_batches
TypeResource
Idazure.ai_agents.vector_store_file_batches

Fields

The following fields are returned by SELECT queries:

NameDatatypeDescription
idstringThe identifier, which can be referenced in API endpoints. Required.
vector_store_idstringThe ID of the vector store that the file is attached to. Required.
created_atstring (date-time)The Unix timestamp (in seconds) for when the vector store files batch was created. Required.
file_countsobjectFiles count grouped by status processed or being processed by this vector store. Required.
objectstringThe object type, which is always vector_store.file_batch. Required. Default value is "vector_store.files_batch".
statusstringThe status of the vector store files batch, which can be either in_progress, completed, cancelled or failed. Required. Known values are: "in_progress", "completed", "cancelled", and "failed". (in_progress, completed, cancelled, failed)

Methods

The following methods are available for this resource:

NameAccessible byRequired ParamsOptional ParamsDescription
getselectvector_store_id, batch_id, endpointRetrieve a vector store file batch.
createinsertvector_store_id, endpointCreate a vector store file batch.
list_filesexecvector_store_id, batch_id, endpointfilter, limit, order, after, beforeReturns a list of vector store files in a batch.
cancelexecvector_store_id, batch_id, endpointCancel a vector store file batch. This attempts to cancel the processing of files in this batch as soon as possible.

Parameters

Parameters can be passed in the WHERE clause of a query. Check the Methods section to see which parameters are required or optional for each operation.

NameDatatypeDescription
batch_idstringIdentifier of the file batch. Required.
endpointstringThe service endpoint host (no scheme), e.g. myaccount.table.cosmos.azure.com:443 - value of the client endpoint parameter. (default: )
vector_store_idstringIdentifier of the vector store. Required.
afterstring
beforestringA cursor for use in pagination. before is an object ID that defines your place in the list. For instance, if you make a list request and receive 100 objects, ending with obj_foo, your subsequent call can include before=obj_foo in order to fetch the previous page of the list. Default value is None.
filterstringFilter by file status. Known values are: "in_progress", "completed", "failed", and "cancelled". Default value is None.
limitintegerA limit on the number of objects to be returned. Limit can range between 1 and 100, and the default is 20. Default value is None.
orderstringSort order by the created_at timestamp of the objects. asc for ascending order and desc for descending order. Known values are: "asc" and "desc". Default value is None.

SELECT examples

Retrieve a vector store file batch.

SELECT
id,
vector_store_id,
created_at,
file_counts,
object,
status
FROM azure.ai_agents.vector_store_file_batches
WHERE vector_store_id = '{{ vector_store_id }}' -- required
AND batch_id = '{{ batch_id }}' -- required
AND endpoint = '{{ endpoint }}' -- required
;

INSERT examples

Create a vector store file batch.

INSERT INTO azure.ai_agents.vector_store_file_batches (
vector_store_id,
endpoint
)
SELECT
'{{ vector_store_id }}',
'{{ endpoint }}'
RETURNING
id,
vector_store_id,
created_at,
file_counts,
object,
status
;

Lifecycle Methods

Returns a list of vector store files in a batch.

EXEC azure.ai_agents.vector_store_file_batches.list_files 
@vector_store_id='{{ vector_store_id }}' --required,
@batch_id='{{ batch_id }}' --required,
@endpoint='{{ endpoint }}' --required,
@filter='{{ filter }}',
@limit='{{ limit }}',
@order='{{ order }}',
@after='{{ after }}',
@before='{{ before }}'
;