steampipe plugin install openai

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
created_attimestamp with time zoneTimestamp of when the model was created.
idtextID of the model, e.g. davinci.
objecttextType of the object, e.g. model.
org_idtext=, !=, ~~, ~~*, !~~, !~~*The ID of the organization.
owned_bytextOrganization that owns the model, e.g. openai.
permissionjsonbPermissions for the model.
roottextRoot of this model.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe 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