Table: openai_model - Query OCI OpenAI Models using SQL

OpenAI Models are a set of pre-trained machine learning models that can be used for a variety of AI tasks. These models can be used for tasks such as text generation, translation, summarization, and more. The models are trained on a large amount of data and can be fine-tuned to perform specific tasks.

Table Usage Guide

The openai_model table provides insights into OpenAI Models within OCI. As a data scientist or AI engineer, explore model-specific details through this table, including model ids, names, and statuses. Utilize it to uncover information about models, such as their configurations, training details, and availability status.

Examples

List models

Explore the various models available in your OpenAI database. This can be useful in identifying and managing the resources in your OpenAI environment.

select
  id
from
  openai_model;

select
  id
from
  openai_model;

Models that allow fine tuning

select
  id
from
  openai_model
where
  (permission -> 0 -> 'allow_fine_tuning') :: bool;

Error: The corresponding SQLite query is unavailable.

Schema for openai_model

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone	Timestamp of when the model was created.
id	text	ID of the model, e.g. davinci.
object	text	Type of the object, e.g. model.
owned_by	text	Organization that owns the model, e.g. openai.
permission	jsonb	Permissions for the model.
root	text	Root of this model.

Export

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- openai

You can pass the configuration to the command with the --config argument:

steampipe_export_openai --config '<your_config>' openai_model