steampipe 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';

Schema for oci_objectstorage_object

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
archival_statetextArchival state of an object. This field is set only for objects in Archive tier.
bucket_nametextThe name of the bucket.
cache_controltextThe Cache-Control header.
content_dispositiontextThe Content-Disposition header.
content_encodingtextThe Content-Encoding header.
content_languagetextThe Content-Language header.
content_rangetextContent-Range header for range requests.
content_typetextThe Content-Type header.
etagtextThe current entity tag (ETag) for the object.
expirestimestamp with time zoneThe date and time after which the object is no longer cached by a browser, proxy, or other caching entity.
is_not_modifiedbooleanFlag to indicate whether or not the object was modified. If this is true, the getter for the object itself will return null.
md5textBase64-encoded MD5 hash of the object data.
nametextThe name of the object.
namespacetextThe Object Storage namespace used for the request.
opc_metajsonbThe user-defined metadata for the object.
opc_multipart_md5textBase-64 representation of the multipart object hash. Only applicable to objects uploaded using multipart upload.
regiontextThe OCI region in which the resource is located.
sizebigintSize of the object in bytes.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
storage_tiertextThe storage tier that the object is stored in.
tenant_idtext=, !=, ~~, ~~*, !~~, !~~*The OCID of the Tenant in which the resource is located.
tenant_nametextThe name of the Tenant in which the resource is located.
time_createdtimestamp with time zoneThe date and time the object was created.
time_modifiedtimestamp with time zoneThe date and time the object was modified.
time_of_archivaltimestamp with time zoneTime that the object is returned to the archived state. This field is only present for restored objects.
titletextTitle of the resource.
version_idtextThe 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