steampipe plugin install ocisteampipe plugin install oci

Table: oci_objectstorage_object - Query OCI Object Storage Objects using SQL

Oracle Cloud Infrastructure's Object Storage is a scalable, secure, and durable solution for storing large amounts of unstructured data. It provides reliable and cost-efficient data durability and allows users to access data from anywhere on the web. This service is ideal for data backup, archival, and big data analytics.

Table Usage Guide

The oci_objectstorage_object table provides insights into the objects within OCI Object Storage. As a data analyst, you can explore object-specific details through this table, including the object's metadata, storage tier, and associated bucket. Utilize it to uncover information about objects, such as their size, time created, and the last time they were modified.

Examples

Basic info

Explore which objects within your Oracle Cloud Infrastructure (OCI) Object Storage have been modified recently. This can help in tracking changes, managing storage space, and maintaining data security.

select
  name,
  bucket_name,
  namespace,
  region,
  size,
  md5,
  time_created,
  time_modified
from
  oci_objectstorage_object;

select
  name,
  bucket_name,
  namespace,
  region,
  size,
  md5,
  time_created,
  time_modified
from
  oci_objectstorage_object;

List archived objects

Explore which objects in your cloud storage have been archived. This is useful for understanding your data retention and could aid in cost management by identifying potentially unnecessary storage.

select
  name,
  bucket_name,
  namespace,
  region,
  archival_state
from
  oci_objectstorage_object
where
  archival_state = 'Archived';

select
  name,
  bucket_name,
  namespace,
  region,
  archival_state
from
  oci_objectstorage_object
where
  archival_state = 'Archived';

Query examples

objectstorage_objects_for_objectstorage_bucket

Schema for oci_objectstorage_object

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
archival_state	text	Archival state of an object. This field is set only for objects in Archive tier.
bucket_name	text	The name of the bucket.
cache_control	text	The Cache-Control header.
content_disposition	text	The Content-Disposition header.
content_encoding	text	The Content-Encoding header.
content_language	text	The Content-Language header.
content_range	text	Content-Range header for range requests.
content_type	text	The Content-Type header.
etag	text	The current entity tag (ETag) for the object.
expires	timestamp with time zone	The date and time after which the object is no longer cached by a browser, proxy, or other caching entity.
is_not_modified	boolean	Flag to indicate whether or not the object was modified. If this is true, the getter for the object itself will return null.
md5	text	Base64-encoded MD5 hash of the object data.
name	text	The name of the object.
namespace	text	The Object Storage namespace used for the request.
opc_meta	jsonb	The user-defined metadata for the object.
opc_multipart_md5	text	Base-64 representation of the multipart object hash. Only applicable to objects uploaded using multipart upload.
region	text	The OCI region in which the resource is located.
size	bigint	Size of the object in bytes.
storage_tier	text	The storage tier that the object is stored in.
tenant_id	text	The OCID of the Tenant in which the resource is located.
tenant_name	text	The name of the Tenant in which the resource is located.
time_created	timestamp with time zone	The date and time the object was created.
time_modified	timestamp with time zone	The date and time the object was modified.
time_of_archival	timestamp with time zone	Time that the object is returned to the archived state. This field is only present for restored objects.
title	text	Title of the resource.
version_id	text	The version ID of the object requested.

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)" -- oci

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

steampipe_export_oci --config '<your_config>' oci_objectstorage_object