code_interpreter_sessions

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

Overview

Name	code_interpreter_sessions
Type	Resource
Id	openai_admin.usage.code_interpreter_sessions

Fields

The following fields are returned by SELECT queries:

list

Usage data retrieved successfully.

Name	Datatype	Description
end_time	integer
object	string	(bucket)
results	array
start_time	integer

Methods

The following methods are available for this resource:

Name	Accessible by	Required Params	Optional Params	Description
list	select	start_time	end_time, bucket_width, project_ids, group_by, limit, page

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.

Name	Datatype	Description
start_time	integer	Start time (Unix seconds) of the query time range, inclusive.
bucket_width	string	Width of each time bucket in response. Currently 1m, 1h and 1d are supported, default to 1d.
end_time	integer	End time (Unix seconds) of the query time range, exclusive.
group_by	array	Group the usage data by the specified fields. Support fields include project_id.
limit	integer	Specifies the number of buckets to return. - bucket_width=1d: default: 7, max: 31 - bucket_width=1h: default: 24, max: 168 - bucket_width=1m: default: 60, max: 1440
page	string	A cursor for use in pagination. Corresponding to the next_page field from the previous response.
project_ids	array	Return only usage for these projects.

SELECT examples

list

Usage data retrieved successfully.

SELECT
end_time,
object,
results,
start_time
FROM openai_admin.usage.code_interpreter_sessions
WHERE start_time = '{{ start_time }}' -- required
AND end_time = '{{ end_time }}'
AND bucket_width = '{{ bucket_width }}'
AND project_ids = '{{ project_ids }}'
AND group_by = '{{ group_by }}'
AND limit = '{{ limit }}'
AND page = '{{ page }}'
;