vector_store_file_batches

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

Overview

Name	vector_store_file_batches
Type	Resource
Id	openai.vector_stores.vector_store_file_batches

Fields

Name	Datatype	Description
id	string	The identifier, which can be referenced in API endpoints.
created_at	integer	The Unix timestamp (in seconds) for when the vector store files batch was created.
file_counts	object
object	string	The object type, which is always vector_store.file_batch.
status	string	The status of the vector store files batch, which can be either in_progress, completed, cancelled or failed.
vector_store_id	string	The ID of the vector store that the File is attached to.

Methods

Name	Accessible by	Required Params	Description
get_vector_store_file_batch	SELECT	batch_id, vector_store_id
create_vector_store_file_batch	INSERT	vector_store_id, data__file_ids
cancel_vector_store_file_batch	EXEC	batch_id, vector_store_id

SELECT examples

SELECT
id,
created_at,
file_counts,
object,
status,
vector_store_id
FROM openai.vector_stores.vector_store_file_batches
WHERE batch_id = '{{ batch_id }}'
AND vector_store_id = '{{ vector_store_id }}';

INSERT example

Use the following StackQL query and manifest file to create a new vector_store_file_batches resource.

Required Properties

/*+ create */
INSERT INTO openai.vector_stores.vector_store_file_batches (
data__file_ids,
data__chunking_strategy,
vector_store_id
)
SELECT 
'{{ file_ids }}',
'{{ chunking_strategy }}',
'{{ vector_store_id }}'
;

All Properties

/*+ create */
INSERT INTO openai.vector_stores.vector_store_file_batches (
data__file_ids,
vector_store_id
)
SELECT 
'{{ file_ids }}',
'{{ vector_store_id }}'
;

Manifest

- name: vector_store_file_batches
  props:
    - name: vector_store_id
      value: string
    - name: data__file_ids
      value: string
    - name: file_ids
      value: array
    - name: chunking_strategy
      props:
        - name: type
          value: string