steampipe plugin install gcp

Table: gcp_compute_target_https_proxy - Query GCP Compute Engine Target HTTPS Proxies using SQL

A Target HTTPS Proxy is a component of GCP Compute Engine used for directing incoming HTTPS traffic to a URL map. It is associated with one or more SSL certificates for secure connections and a URL map that routes the traffic. Target HTTPS Proxies are regional resources and are required by external HTTP(S) load balancers.

Table Usage Guide

The gcp_compute_target_https_proxy table provides insights into Target HTTPS Proxies within Google Cloud Compute Engine. As a network engineer, explore proxy-specific details through this table, including associated SSL certificates, URL maps, and regional settings. Utilize it to uncover information about proxies, such as their configurations, the SSL/TLS settings, and the routing of HTTPS traffic.

Examples

Basic info

Explore the configuration of your HTTPS proxy settings in Google Cloud Platform (GCP) to identify potential issues or areas for improvement. This query will assist you in gaining insights into the binding status of your proxies, enhancing your network's performance and security.

select
name,
id,
self_link,
proxy_bind
from
gcp_compute_target_https_proxy;
select
name,
id,
self_link,
proxy_bind
from
gcp_compute_target_https_proxy;

Get SSL policy details for each target HTTPS proxy

Analyze the settings to understand the SSL policy associated with each target HTTPS proxy in your Google Cloud Compute environment. This could be beneficial for maintaining security standards and protocols across your digital assets.

select
name,
id,
ssl_policy
from
gcp_compute_target_https_proxy;
select
name,
id,
ssl_policy
from
gcp_compute_target_https_proxy;

Schema for gcp_compute_target_https_proxy

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
authorization_policytextSpecifies an URL referring to a networksecurity.
creation_timestamptimestamp with time zoneSpecifies the time when the resource is created.
descriptiontextA user defined description for the resource.
idbigintA server-defined unique identifier for the resource.
kindtextType of the resource. Always compute#targetHttpsProxy for target HTTPS proxies.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
location_typetextLocation type where the target https proxy resides.
nametext=Name of the resource. Provided by the client when the resource is created.
projecttext=, !=, ~~, ~~*, !~~, !~~*The GCP Project in which the resource is located.
proxy_bindboolean!=, =This field only applies when the forwarding rule that references this target proxy has a loadBalancingScheme set to INTERNAL_SELF_MANAGED.
quic_overridetextSpecifies the QUIC override policy for this TargetHttpsProxy resource.
regiontextAn URL of the region where the regional TargetHttpsProxy resides.
self_linktextServer-defined URL for the resource.
server_tls_policytextAn URL referring to a networksecurity.ServerTlsPolicy resource that describes how the proxy should authenticate inbound traffic.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
ssl_certificatesjsonbA list of URLs to SslCertificate resources that are used to authenticate connections between users and the load balancer.
ssl_policytextAn URL of SslPolicy resource that will be associated with the TargetHttpsProxy resource.
titletextTitle of the resource.
url_maptextA fully-qualified or valid partial URL to the UrlMap resource that defines the mapping from URL to the BackendService.

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)" -- gcp

You can pass the configuration to the command with the --config argument:

steampipe_export_gcp --config '<your_config>' gcp_compute_target_https_proxy