steampipe plugin install gcp

Table: gcp_dns_record_set - Query GCP DNS Record Sets using SQL

A DNS Record Set in Google Cloud Platform (GCP) is a collection of DNS records of the same type that share the same domain name. They are used to map a domain name to an IP address or other data. DNS Record Sets are essential for the functioning of the internet, enabling the translation of human-readable domain names into numerical IP addresses that computers can understand.

Table Usage Guide

The gcp_dns_record_set table provides insights into DNS Record Sets within Google Cloud Platform (GCP). As a network engineer, explore details of each record set through this table, including record types, record data, and associated metadata. Utilize it to uncover information about DNS configurations, such as those with potential misconfigurations, the mapping of domain names to IP addresses, and the verification of DNS configurations.

Examples

Basic info

Explore the configuration of your Google Cloud Platform DNS record sets to gain insights into their management zones, types, routing policies, and time-to-live (TTL) settings. This is useful for understanding your DNS infrastructure and making necessary changes for optimal performance.

select
name,
managed_zone_name,
type,
kind,
routing_policy,
rrdatas,
signature_rrdatas,
ttl
from
gcp_dns_record_set;
select
name,
managed_zone_name,
type,
kind,
routing_policy,
rrdatas,
signature_rrdatas,
ttl
from
gcp_dns_record_set;

List CNAME record sets

Explore which alias domain names are associated with actual domain names in your Google Cloud DNS. This is useful for managing and maintaining DNS records, ensuring proper redirections, and troubleshooting potential issues.

select
name,
managed_zone_name,
type,
ttl
from
gcp_dns_record_set
where
type = 'CNAME';
select
name,
managed_zone_name,
type,
ttl
from
gcp_dns_record_set
where
type = 'CNAME';

Schema for gcp_dns_record_set

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
akasjsonbArray of globally unique identifier strings (also known as) for the resource.
kindtextThe type of the resource.
locationtextThe GCP multi-region, region, or zone in which the resource is located.
managed_zone_nametext=An user assigned, friendly name that identifies the managed zone.
nametext=The name of the record set.
projecttext=, !=, ~~, ~~*, !~~, !~~*The GCP Project in which the resource is located.
routing_policyjsonbConfigures dynamic query responses based on geo location of querying user or a weighted round robin based routing policy. A ResourceRecordSet should only have either rrdata (static) or routing_policy(dynamic). An error is returned otherwise.
rrdatasjsonbAs defined in RFC 1035 (section 5) and RFC 1034 (section 3.6.1).
signature_rrdatasjsonbAs defined in RFC 4034 (section 3.2).
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
titletextTitle of the resource.
ttlbigintNumber of seconds that this ResourceRecordSet can be cached by resolvers.
typetext=The identifier of a supported record type. See the list of Supported DNS record types.

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_dns_record_set