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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form.
akas	jsonb		Array of globally unique identifier strings (also known as) for the resource.
kind	text		The type of the resource.
location	text		The GCP multi-region, region, or zone in which the resource is located.
managed_zone_name	text	=	An user assigned, friendly name that identifies the managed zone.
name	text	=	The name of the record set.
project	text	=, !=, ~~, ~~, !~~, !~~	The GCP Project in which the resource is located.
routing_policy	jsonb		Configures 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.
rrdatas	jsonb		As defined in RFC 1035 (section 5) and RFC 1034 (section 3.6.1).
signature_rrdatas	jsonb		As defined in RFC 4034 (section 3.2).
sp_connection_name	text	=, !=, ~~, ~~, !~~, !~~	Steampipe connection name.
sp_ctx	jsonb		Steampipe context in JSON form.
title	text		Title of the resource.
ttl	bigint		Number of seconds that this ResourceRecordSet can be cached by resolvers.
type	text	=	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