Table: openstack_router

A router is a logical component used to forward packages between different networks. It provides NAT forwarding to allow external access to instances.

Examples

Basic router info

select
  name,
  description,
  status,
  id,
  project_id
from
  openstack_router;

Router by ID

select
  name,
  description,
  status,
  id,
  project_id
from
  openstack_router
where
  id = '962adcf6-a93a-4402-a90a-4f9ce60e239e';

All active routers

select
  name,
  description,
  status,
  id,
  project_id
from
  openstack_router
where
  status = 'ACTIVE';

Schema for openstack_router

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
admin_state_up	text		AdminStateUp is the administrative state of the router.
availability_zone_hints	jsonb		Availability zone hints groups network nodes that run services like DHCP, L3, FW, and others. Used to make network resources highly available.
description	text		Description for the router.
distributed	boolean		Distributed is whether router is disitrubted or not.
gateway_info_enable_SNAT	boolean		GatewayInfo represents the information of an external gateway for any particular network router.
gateway_info_external_fixed_IPs	jsonb		GatewayInfo represents the information of an external gateway for any particular network router.
gateway_info_network_ID	text		GatewayInfo represents the information of an external gateway for any particular network router.
id	text	=	ID is the unique identifier for the router.
name	text		Name is the human readable name for the router. It does not have to be unique.
project_id	text		ProjectID is the project owner of the router.
routes	jsonb		Routes are a collection of static routes that the router will host.
status	text		Status indicates whether or not a router is currently operational.
tags	jsonb		Tags optionally set via extensions/attributestags.
tenant_id	text		TenantID is the project owner of the router. Only admin users can specify a project identifier other than its own.