jobs

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

Overview

Name	jobs
Type	Resource
Id	openai.fine_tuning.jobs

Fields

Name	Datatype	Description
id	string	The object identifier, which can be referenced in the API endpoints.
created_at	integer	The Unix timestamp (in seconds) for when the fine-tuning job was created.
error	object	For fine-tuning jobs that have failed, this will contain more information on the cause of the failure.
estimated_finish	integer	The Unix timestamp (in seconds) for when the fine-tuning job is estimated to finish. The value will be null if the fine-tuning job is not running.
fine_tuned_model	string	The name of the fine-tuned model that is being created. The value will be null if the fine-tuning job is still running.
finished_at	integer	The Unix timestamp (in seconds) for when the fine-tuning job was finished. The value will be null if the fine-tuning job is still running.
hyperparameters	object	The hyperparameters used for the fine-tuning job. See the fine-tuning guide for more details.
integrations	array	A list of integrations to enable for this fine-tuning job.
model	string	The base model that is being fine-tuned.
object	string	The object type, which is always "fine_tuning.job".
organization_id	string	The organization that owns the fine-tuning job.
result_files	array	The compiled results file ID(s) for the fine-tuning job. You can retrieve the results with the Files API.
seed	integer	The seed used for the fine-tuning job.
status	string	The current status of the fine-tuning job, which can be either validating_files, queued, running, succeeded, failed, or cancelled.
trained_tokens	integer	The total number of billable tokens processed by this fine-tuning job. The value will be null if the fine-tuning job is still running.
training_file	string	The file ID used for training. You can retrieve the training data with the Files API.
validation_file	string	The file ID used for validation. You can retrieve the validation results with the Files API.

Methods

Name	Accessible by	Required Params	Description
list_paginated_fine_tuning_jobs	SELECT
retrieve_fine_tuning_job	SELECT	fine_tuning_job_id
create_fine_tuning_job	INSERT	data__model, data__training_file
cancel_fine_tuning_job	EXEC	fine_tuning_job_id

SELECT examples

SELECT
id,
created_at,
error,
estimated_finish,
fine_tuned_model,
finished_at,
hyperparameters,
integrations,
model,
object,
organization_id,
result_files,
seed,
status,
trained_tokens,
training_file,
validation_file
FROM openai.fine_tuning.jobs
;

INSERT example

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

Required Properties

/*+ create */
INSERT INTO openai.fine_tuning.jobs (
data__model,
data__training_file,
data__hyperparameters,
data__suffix,
data__validation_file,
data__integrations,
data__seed
)
SELECT 
'{{ model }}',
'{{ training_file }}',
'{{ hyperparameters }}',
'{{ suffix }}',
'{{ validation_file }}',
'{{ integrations }}',
'{{ seed }}'
;

All Properties

/*+ create */
INSERT INTO openai.fine_tuning.jobs (
data__model,
data__training_file
)
SELECT 
'{{ model }}',
'{{ training_file }}'
;

Manifest

- name: jobs
  props:
    - name: data__model
      value: string
    - name: data__training_file
      value: string
    - name: model
      value: string
    - name: training_file
      value: string
    - name: hyperparameters
      props:
        - name: batch_size
          value: string
        - name: learning_rate_multiplier
          value: string
        - name: n_epochs
          value: string
    - name: suffix
      value: string
    - name: validation_file
      value: string
    - name: integrations
      value: array
      props:
        - name: type
          value: string
        - name: wandb
          props:
            - name: project
              value: string
            - name: name
              value: string
            - name: entity
              value: string
            - name: tags
              value: array
    - name: seed
      value: integer