steampipe plugin install ocisteampipe plugin install oci

oci_ai_anomaly_detection_ai_private_endpoint oci_ai_anomaly_detection_data_asset oci_ai_anomaly_detection_model oci_ai_anomaly_detection_project oci_analytics_instance oci_apigateway_api oci_artifacts_container_image oci_artifacts_container_image_signature oci_artifacts_container_repository oci_artifacts_generic_artifact oci_artifacts_repository oci_autoscaling_auto_scaling_configuration oci_bastion_bastion oci_bastion_session oci_budget_alert_rule oci_budget_budget oci_cloud_guard_configuration oci_cloud_guard_detector_recipe oci_cloud_guard_managed_list oci_cloud_guard_responder_recipe oci_cloud_guard_target oci_containerengine_cluster oci_core_block_volume_replica oci_core_boot_volume oci_core_boot_volume_attachment oci_core_boot_volume_backup oci_core_boot_volume_metric_read_ops oci_core_boot_volume_metric_read_ops_daily oci_core_boot_volume_metric_read_ops_hourly oci_core_boot_volume_metric_write_ops oci_core_boot_volume_metric_write_ops_daily oci_core_boot_volume_metric_write_ops_hourly oci_core_boot_volume_replica oci_core_cluster_network oci_core_dhcp_options oci_core_drg oci_core_image oci_core_image_custom oci_core_instance oci_core_instance_configuration oci_core_instance_metric_cpu_utilization oci_core_instance_metric_cpu_utilization_daily oci_core_instance_metric_cpu_utilization_hourly oci_core_internet_gateway oci_core_load_balancer oci_core_local_peering_gateway oci_core_nat_gateway oci_core_network_load_balancer oci_core_network_security_group oci_core_public_ip oci_core_public_ip_pool oci_core_route_table oci_core_security_list oci_core_service_gateway oci_core_subnet oci_core_vcn oci_core_vnic_attachment oci_core_volume oci_core_volume_attachment oci_core_volume_backup oci_core_volume_backup_policy oci_core_volume_default_backup_policy oci_core_volume_group oci_database_autonomous_database oci_database_autonomous_db_metric_cpu_utilization oci_database_autonomous_db_metric_cpu_utilization_daily oci_database_autonomous_db_metric_cpu_utilization_hourly oci_database_autonomous_db_metric_storage_utilization oci_database_autonomous_db_metric_storage_utilization_daily oci_database_autonomous_db_metric_storage_utilization_hourly oci_database_db oci_database_db_home oci_database_db_system oci_database_pluggable_database oci_database_software_image oci_dns_rrset oci_dns_tsig_key oci_dns_zone oci_events_rule oci_file_storage_file_system oci_file_storage_mount_target oci_file_storage_snapshot oci_functions_application oci_functions_function oci_identity_api_key oci_identity_auth_token oci_identity_authentication_policy oci_identity_availability_domain oci_identity_compartment oci_identity_customer_secret_key oci_identity_dynamic_group oci_identity_group oci_identity_network_source oci_identity_policy oci_identity_tag_default oci_identity_tag_namespace oci_identity_tenancy oci_identity_user oci_kms_key oci_kms_key_version oci_kms_vault oci_logging_log oci_logging_log_group oci_mysql_backup oci_mysql_channel oci_mysql_configuration oci_mysql_configuration_custom oci_mysql_db_system oci_mysql_db_system_metric_connections oci_mysql_db_system_metric_connections_daily oci_mysql_db_system_metric_connections_hourly oci_mysql_db_system_metric_cpu_utilization oci_mysql_db_system_metric_cpu_utilization_daily oci_mysql_db_system_metric_cpu_utilization_hourly oci_mysql_db_system_metric_memory_utilization oci_mysql_db_system_metric_memory_utilization_daily oci_mysql_heat_wave_cluster oci_network_firewall_firewall oci_network_firewall_policy oci_nosql_table oci_nosql_table_metric_read_throttle_count oci_nosql_table_metric_read_throttle_count_daily oci_nosql_table_metric_read_throttle_count_hourly oci_nosql_table_metric_storage_utilization oci_nosql_table_metric_storage_utilization_daily oci_nosql_table_metric_storage_utilization_hourly oci_nosql_table_metric_write_throttle_count oci_nosql_table_metric_write_throttle_count_daily oci_nosql_table_metric_write_throttle_count_hourly oci_objectstorage_bucket oci_objectstorage_object oci_ons_notification_topic oci_ons_subscription oci_queue_queue oci_region oci_resource_search oci_resourcemanager_stack oci_streaming_stream oci_vault_secret

Table: oci_nosql_table

A NoSQL database service offering on-demand throughput and storage based provisioning that supports JSON, Table and Key-Value datatypes, all with flexible transaction guarantees.

Examples

Basic info

select
  name,
  id,
  lifecycle_state,
  time_created
from
  oci_nosql_table;

List tables that are not active

select
  name,
  id,
  lifecycle_state,
  time_created
from
  oci_nosql_table
where
  lifecycle_state <> 'ACTIVE';

List tables with disk storage greater than 1024 GB

select
  name,
  id,
  lifecycle_state,
  time_created
from
  oci_nosql_table
where
  cast(table_limits -> 'maxStorageInGBs' as INTEGER) > 1024;

Query examples

Control examples

nosql_table_stale_data

.inspect oci_nosql_table

OCI NoSQL Table

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
compartment_id	text	The OCID of the compartment in Tenant in which the resource is located.
ddl_statement	text	A DDL statement representing the schema.
defined_tags	jsonb	Defined 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.
freeform_tags	jsonb	Free-form tags for resource. This tags can be applied by any user with permissions on the resource.
id	text	Unique identifier that is immutable.
is_auto_reclaimable	boolean	True if this table can be reclaimed after an idle period.
lifecycle_details	text	A message describing the current state in more detail.
lifecycle_state	text	The state of a table.
name	text	Immutable human-friendly table name.
region	text	The OCI region in which the resource is located.
schema	jsonb	The schema of the table.
system_tags	jsonb	System tags for resource. System tags can be viewed by users, but can only be created by the system.
table_limits	jsonb	Various limit for the table.
tags	jsonb	A map of tags for the resource.
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 time the the table was created.
time_of_expiration	timestamp with time zone	If lifecycleState is INACTIVE, indicates when this table will be automatically removed.
time_updated	timestamp with time zone	The time the the table was updated.
title	text	Title of the resource.