steampipe plugin install ocisteampipe plugin install oci
oci_analytics_instanceoci_apigateway_apioci_autoscaling_auto_scaling_configurationoci_budget_alert_ruleoci_budget_budgetoci_cloud_guard_configurationoci_cloud_guard_detector_recipeoci_cloud_guard_managed_listoci_cloud_guard_responder_recipeoci_cloud_guard_targetoci_core_block_volume_replicaoci_core_boot_volumeoci_core_boot_volume_attachmentoci_core_boot_volume_backupoci_core_boot_volume_metric_read_opsoci_core_boot_volume_metric_read_ops_dailyoci_core_boot_volume_metric_read_ops_hourlyoci_core_boot_volume_metric_write_opsoci_core_boot_volume_metric_write_ops_dailyoci_core_boot_volume_metric_write_ops_hourlyoci_core_boot_volume_replicaoci_core_dhcp_optionsoci_core_drgoci_core_imageoci_core_image_customoci_core_instanceoci_core_instance_metric_cpu_utilizationoci_core_instance_metric_cpu_utilization_dailyoci_core_instance_metric_cpu_utilization_hourlyoci_core_internet_gatewayoci_core_load_balanceroci_core_local_peering_gatewayoci_core_nat_gatewayoci_core_network_load_balanceroci_core_network_security_groupoci_core_public_ipoci_core_public_ip_pooloci_core_route_tableoci_core_security_listoci_core_service_gatewayoci_core_subnetoci_core_vcnoci_core_volumeoci_core_volume_attachmentoci_core_volume_backupoci_core_volume_backup_policyoci_database_autonomous_databaseoci_database_autonomous_database_metric_cpu_utilizationoci_database_autonomous_database_metric_cpu_utilization_dailyoci_database_autonomous_database_metric_storage_utilizationoci_database_autonomous_database_metric_storage_utilization_daioci_database_dboci_database_db_homeoci_database_db_systemoci_database_software_imageoci_dns_rrsetoci_dns_tsig_keyoci_dns_zoneoci_events_ruleoci_file_storage_file_systemoci_file_storage_mount_targetoci_file_storage_snapshotoci_functions_applicationoci_identity_api_keyoci_identity_auth_tokenoci_identity_authentication_policyoci_identity_availability_domainoci_identity_compartmentoci_identity_customer_secret_keyoci_identity_dynamic_groupoci_identity_groupoci_identity_network_sourceoci_identity_policyoci_identity_tag_defaultoci_identity_tag_namespaceoci_identity_tenancyoci_identity_useroci_kms_keyoci_kms_key_versionoci_kms_vaultoci_logging_logoci_logging_log_groupoci_mysql_backupoci_mysql_channeloci_mysql_configurationoci_mysql_configuration_customoci_mysql_db_systemoci_mysql_db_system_metric_connectionsoci_mysql_db_system_metric_connections_dailyoci_mysql_db_system_metric_cpu_utilizationoci_mysql_db_system_metric_cpu_utilization_dailyoci_mysql_db_system_metric_memory_utilizationoci_mysql_db_system_metric_memory_utilization_dailyoci_nosql_tableoci_nosql_table_metric_read_throttle_countoci_nosql_table_metric_read_throttle_count_dailyoci_nosql_table_metric_read_throttle_count_hourlyoci_nosql_table_metric_storage_utilizationoci_nosql_table_metric_storage_utilization_dailyoci_nosql_table_metric_storage_utilization_hourlyoci_nosql_table_metric_write_throttle_countoci_nosql_table_metric_write_throttle_count_dailyoci_nosql_table_metric_write_throttle_count_hourlyoci_objectstorage_bucketoci_ons_notification_topicoci_ons_subscriptionoci_regionoci_resource_search

Table: oci_objectstorage_bucket

The Oracle Cloud Infrastructure Object Storage service is an internet-scale, high-performance storage platform that offers reliable and cost-efficient data durability

Examples

Basic info

select
name,
id,
namespace,
storage_tier,
is_read_only
from
oci_objectstorage_bucket;

List public buckets

select
id,
name,
namespace,
public_access_type
from
oci_objectstorage_bucket
where
public_access_type LIKE 'Object%';

List buckets with versioning disabled

select
id,
name,
namespace,
versioning
from
oci_objectstorage_bucket
where
versioning = 'Disabled';

List buckets with object events disabled

select
id,
name,
namespace,
object_events_enabled
from
oci_objectstorage_bucket
where
not object_events_enabled;

List buckets with replication disabled

select
id,
name,
namespace,
replication_enabled
from
oci_objectstorage_bucket
where
not replication_enabled;

List buckets without lifecycle

select
name,
id,
object_lifecycle_policy -> 'items' as object_lifecycle_policy_rules
from
oci_objectstorage_bucket
where
object_lifecycle_policy ->> 'items' is null
or jsonb_array_length(object_lifecycle_policy -> 'items') = 0;

Query examples

Control examples

.inspect oci_objectstorage_bucket

OCI ObjectStorage Bucket

NameTypeDescription
approximate_countbigintThe approximate number of objects in the bucket.
approximate_sizebigintThe approximate total size in bytes of all objects in the bucket..
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
created_bytextThe OCID of the user who created the bucket.
defined_tagsjsonbDefined tags for resource. Defined tags are set up in your tenancy by an administrator. Only users granted permission to work with the defined tags can apply them to resources.
etagtextThe entity tag (ETag) for the bucket.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the bucket.
is_read_onlybooleanWhether or not this bucket is read only.
kms_key_idtextThe OCID of a master encryption key used to call the Key Management service to generate a data encryption key or to encrypt or decrypt a data encryption key.
metadatajsonbArbitrary string keys and values for user-defined metadata.
nametextThe name of the bucket.
namespacetextThe Object Storage namespace in which the bucket lives.
object_events_enabledbooleanWhether or not events are emitted for object state changes in this bucket.
object_lifecycle_policyjsonbSpecifies the object lifecycle policy for the bucket.
object_lifecycle_policy_etagtextThe entity tag (ETag) for the live object lifecycle policy on the bucket.
public_access_typetextThe type of public access enabled on this bucket.
regiontextThe OCI region in which the resource is located.
replication_enabledbooleanWhether or not this bucket is a replication source.
storage_tiertextThe storage tier type assigned to the bucket.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtextThe date and time the bucket was created.
titletextTitle of the resource.
versioningtextThe versioning status on the bucket.