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	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
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.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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