Table: oci_core_internet_gateway - Query OCI Core Internet Gateways using SQL

An OCI Core Internet Gateway is a virtual router that provides a path for traffic between your VCN and the internet. As a stateless gateway, it does not maintain information about the traffic that flows through it. It also does not perform Network Address Translation (NAT) or route table lookups.

Table Usage Guide

The oci_core_internet_gateway table provides insights into the Internet Gateways within Oracle Cloud Infrastructure (OCI). As a network engineer, explore gateway-specific details through this table, including its lifecycle state, availability domain, and associated metadata. Utilize it to uncover information about gateways, such as their attached VCNs, the time they were created, and whether they are enabled for internet traffic.

Examples

Basic info

Gain insights into the creation and lifecycle status of your internet gateway resources in Oracle Cloud Infrastructure. This is useful for managing and monitoring the state and duration of these resources in your network.

select
  display_name,
  id,
  time_created,
  lifecycle_state as state
from
  oci_core_internet_gateway;

select
  display_name,
  id,
  time_created,
  lifecycle_state as state
from
  oci_core_internet_gateway;

List disabled internet gateways

Identify instances where internet gateways are disabled to understand potential gaps in your network infrastructure. This can help in improving the security and reliability of your systems.

select
  display_name,
  id,
  time_created,
  is_enabled
from
  oci_core_internet_gateway
where
  not is_enabled;

select
  display_name,
  id,
  time_created,
  is_enabled
from
  oci_core_internet_gateway
where
  not is_enabled;

Query examples

Schema for oci_core_internet_gateway

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
compartment_id	text	=	The OCID of the compartment in Tenant in which the resource is located.
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.
display_name	text	=	A user-friendly name.
freeform_tags	jsonb		Free-form tags for resource. This tags can be applied by any user with permissions on the resource.
id	text	=	The internet gateway's Oracle ID (OCID).
is_enabled	boolean		Whether the gateway is enabled.
lifecycle_state	text	=	The internet gateway's current state.
region	text		The OCI region in which the resource is located.
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
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 date and time the internet gateway was created.
title	text		Title of the resource.
vcn_id	text	=	The OCID of the VCN the internet gateway belongs to.

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_core_internet_gateway