turbot/gcp

steampipe plugin install gcpsteampipe plugin install gcp
gcp_audit_policygcp_bigquery_datasetgcp_bigquery_jobgcp_bigquery_tablegcp_bigtable_instancegcp_cloudfunctions_functiongcp_compute_addressgcp_compute_backend_bucketgcp_compute_backend_servicegcp_compute_diskgcp_compute_disk_metric_read_opsgcp_compute_disk_metric_read_ops_dailygcp_compute_disk_metric_read_ops_hourlygcp_compute_disk_metric_write_opsgcp_compute_disk_metric_write_ops_dailygcp_compute_disk_metric_write_ops_hourlygcp_compute_firewallgcp_compute_forwarding_rulegcp_compute_global_addressgcp_compute_global_forwarding_rulegcp_compute_imagegcp_compute_instancegcp_compute_instance_metric_cpu_utilizationgcp_compute_instance_metric_cpu_utilization_dailygcp_compute_instance_metric_cpu_utilization_hourlygcp_compute_instance_templategcp_compute_machine_typegcp_compute_networkgcp_compute_node_groupgcp_compute_node_templategcp_compute_project_metadatagcp_compute_regiongcp_compute_resource_policygcp_compute_routergcp_compute_snapshotgcp_compute_ssl_policygcp_compute_subnetworkgcp_compute_target_https_proxygcp_compute_target_poolgcp_compute_target_ssl_proxygcp_compute_target_vpn_gatewaygcp_compute_url_mapgcp_compute_vpn_tunnelgcp_compute_zonegcp_dns_managed_zonegcp_dns_policygcp_dns_record_setgcp_iam_policygcp_iam_rolegcp_kms_keygcp_kms_key_ringgcp_logging_bucketgcp_logging_exclusiongcp_logging_metricgcp_logging_sinkgcp_monitoring_alert_policygcp_monitoring_groupgcp_monitoring_notification_channelgcp_organizationgcp_projectgcp_project_organization_policygcp_project_servicegcp_pubsub_snapshotgcp_pubsub_subscriptiongcp_pubsub_topicgcp_service_accountgcp_service_account_keygcp_sql_backupgcp_sql_databasegcp_sql_database_instancegcp_sql_database_instance_metric_connectionsgcp_sql_database_instance_metric_connections_dailygcp_sql_database_instance_metric_connections_hourlygcp_sql_database_instance_metric_cpu_utilizationgcp_sql_database_instance_metric_cpu_utilization_dailygcp_sql_database_instance_metric_cpu_utilization_hourlygcp_storage_bucket

Table: gcp_compute_forwarding_rule

Compute forwarding rule and its corresponding IP address represent the frontend configuration of a Google Cloud load balancer. A forwarding rule specifies a backend service, target proxy, or target pool. A forwarding rule and its IP address are internal or external.

Basic info

select
name,
id,
self_link,
backend_service,
ip_address,
load_balancing_scheme
from
gcp_compute_forwarding_rule;

List of forwarding rules which are not globally accessible

select
name,
id,
allow_global_access
from
gcp_compute_forwarding_rule
where
not allow_global_access;

List of EXTERNAL forwarding rules

select
name,
id,
load_balancing_scheme
from
gcp_compute_forwarding_rule
where
load_balancing_scheme = 'EXTERNAL';

.inspect gcp_compute_forwarding_rule

GCP Compute Forwarding Rule

NameTypeDescription
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
all_portsbooleanSpecify this field to allow packets addressed to any ports will be forwarded to the backends configured with this forwarding rule.
allow_global_accessbooleanSpecifies whether clients can access ILB from all regions, or not.
backend_servicetextSpecifies the BackendService resource to receive the matched traffic.
creation_timestamptimestamp without time zoneThe creation timestamp of the resource.
descriptiontextA user-specified, human-readable description of the resource.
fingerprinttexta hash of the contents stored in this object and used for optimistic locking.
idbigintThe unique identifier for the resource.
ip_addressinetSpecifies the IP address that this forwarding rule serves.
ip_protocoltextThe IP protocol to which this rule applies.
ip_versiontextThe IP Version that will be used by this forwarding rule.
is_mirroring_collectorbooleanIndicates whether or not this load balancer can be used as a collector for packet mirroring.
kindtextThe type of the resource.
labelsjsonbA list of labels attached to this resource.
load_balancing_schemetextSpecifies the forwarding rule type.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
metadata_filtersjsonbOpaque filter criteria used by Loadbalancer to restrict routing configuration to a limited set of xDS compliant clients.
nametextA friendly name that identifies the resource.
networktextSpecifies the network that the load balanced IP should belong to for this Forwarding Rule.
network_tiertextSpecifies tthe networking tier used for configuring this load balancer.
port_rangetextSpecifies the port range. Packets addressed to ports in the specified range will be forwarded to target or backendService.
portsjsonbA list of ports can be configured.
projecttextThe GCP Project in which the resource is located.
regiontextThe URL of the region where the regional forwarding rule resides.
self_linktextThe server-defined URL for the resource.
service_labeltextA prefix to the service name for this Forwarding Rule. If specified, the prefix is the first label of the fully qualified service name.
service_nametextThe internal fully qualified service name for this Forwarding Rule.
subnetworktextSpecifies the subnetwork that the load balanced IP should belong to for this Forwarding Rule.
tagsjsonbA map of tags for the resource.
targettextThe URL of the target resource to receive the matched traffic.
titletextTitle of the resource.