turbot/oci

steampipe plugin install ocisteampipe plugin install oci
On This Page
Get Involved

Table: oci_core_service_gateway

A service gateway enables cloud resources without public IP addresses to privately access Oracle services.

Examples

Basic info

select
display_name,
id,
time_created,
vcn_id,
lifecycle_state,
region
from
oci_core_service_gateway;

List service gateways that use route tables

select
display_name,
id,
route_table_id
from
oci_core_service_gateway
where
route_table_id is not null;

Get enabled services for each service gateway

select
display_name,
id,
s ->> 'serviceId' as service_id,
s ->> 'serviceName' as service_name
from
oci_core_service_gateway,
jsonb_array_elements(services) as s;

List service gateways that block traffic

select
display_name,
id,
block_traffic
from
oci_core_service_gateway
where
block_traffic;

.inspect oci_core_service_gateway

OCI Core Service Gateway

NameTypeDescription
block_trafficbooleanSpecifies whether the service gateway blocks traffic through it.
compartment_idtextThe OCID of the compartment in Tenant in which the resource is located.
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.
display_nametextA user-friendly name of the service gateway.
freeform_tagsjsonbFree-form tags for resource. This tags can be applied by any user with permissions on the resource.
idtextThe OCID of the service gateway.
lifecycle_statetextThe service gateway's current state.
regiontextThe OCI region in which the resource is located.
route_table_idtextThe OCID of the route table the service gateway is using.
servicesjsonbList of the Service objects enabled for this service gateway.
tagsjsonbA map of tags for the resource.
tenant_idtextThe OCID of the Tenant in which the resource is located.
time_createdtimestamp without time zoneThe date and time the service gateway was created
titletextTitle of the resource.
vcn_idtextThe OCID of the VCN the service gateway belongs to.