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	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
org_id	text	=, !=, ~~, ~~, !~~, !~~	The ID of the organization.
owned_by	text		Organization that owns the model, e.g. openai.
permission	jsonb		Permissions for the model.
root	text		Root of this model.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.

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