Table: openai_file - Query OpenAI Files using SQL

OpenAI File is a resource within OpenAI that represents the data files used for training models. It provides detailed information about each file including its ID, name, purpose, and status. OpenAI File is vital for understanding the data used in model training and for keeping track of file statuses.

Table Usage Guide

The openai_file table provides insights into the data files within OpenAI used for training models. As a data scientist or AI engineer, explore file-specific details through this table, including file ID, filename, purpose, and status. Utilize it to understand the data used in model training, monitor the status of files, and manage your resources effectively.

Examples

List files

Explore which files are taking up the most space in your system. This is particularly useful for managing storage and identifying large files that may no longer be necessary.

select
  id,
  file_name,
  bytes
from
  openai_file;

select
  id,
  file_name,
  bytes
from
  openai_file;

Schema for openai_file

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
bytes	bigint		Size of the file in bytes
created_at	timestamp with time zone		Timestamp of when the file was created.
file_name	text		Name of the file.
id	text	=	ID of the file, e.g. davinci.
object	text		The type of the uploaded document, e.g. file.
org_id	text	=, !=, ~~, ~~, !~~, !~~	The ID of the organization.
owner	text		Organization that owns the file, e.g. openai.
purpose	text		The intended purpose of the uploaded documents.
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_file