Skip to content
AWS for Query.Farm

aws.route53.get_hosted_zone

Example SQL Queries

SELECT * FROM
aws.route53.get_hosted_zone
WHERE
"id" = 'VALUE';

Description

Gets information about a specified hosted zone including the four name servers assigned to the hosted zone.

Table Definition

Column NameColumn Data Type
id Required Input Column

The ID of the hosted zone that you want to get information about.

VARCHAR
_aws_profile Input Column

The AWS profile defines the AWS identity used. It can be defined via credentials or by assuming a IAM role.

STRUCT(
    "type" VARCHAR,
    "name" VARCHAR,
    "account_id" VARCHAR,
    "via_profile_name" VARCHAR,
    "assumed_role_arn" VARCHAR,
    "organization" STRUCT(
        "account_name" VARCHAR,
        "id" VARCHAR,
        "tags" STRUCT(
            "key" VARCHAR,
            "value" VARCHAR
        )[],
        "master_account" STRUCT(
            "id" VARCHAR,
            "email" VARCHAR
        ),
        "parents" STRUCT(
            "type" VARCHAR,
            "id" VARCHAR,
            "name" VARCHAR,
            "tags" STRUCT(
                "key" VARCHAR,
                "value" VARCHAR
            )[]
        )[]
    )
)
Show child fields
_aws_profile.account_id

The AWS account id

_aws_profile.assumed_role_arn

The ARN of the assumed role

_aws_profile.name

The unique name of the profile.

_aws_profile.organization

Information about this profile's membership in the AWS organization.

Show child fields
_aws_profile.organization.account_name

The name of account speciifed by the organization

_aws_profile.organization.id

The organization id

_aws_profile.organization.master_account
Show child fields
_aws_profile.organization.master_account.email

The organization master account email address

_aws_profile.organization.master_account.id

The organization master account id

_aws_profile.organization.parents[]
Show child fields
_aws_profile.organization.parents[].id

The id of the parent

_aws_profile.organization.parents[].name

The name of the parent

_aws_profile.organization.parents[].tags[]
Show child fields
_aws_profile.organization.parents[].tags[].key
_aws_profile.organization.parents[].tags[].value
_aws_profile.organization.parents[].type

The type of parent can be an organization unit or a root

_aws_profile.organization.tags[]
Show child fields
_aws_profile.organization.tags[].key
_aws_profile.organization.tags[].value
_aws_profile.type

The type of profile, either 'credentials' or 'assumed_role'

_aws_profile.via_profile_name

This IAM role for this profile is assumed by first utilizing another profile with this name to obtain credentials.

delegation_set

A complex type that lists the Amazon Route 53 name servers for the specified hosted zone.

STRUCT(
    "id" VARCHAR,
    "caller_reference" VARCHAR,
    "name_servers" VARCHAR[]
)
Show child fields
delegation_set.caller_reference

The value that you specified for CallerReference when you created the reusable delegation set.

delegation_set.id

The ID that Amazon Route 53 assigns to a reusable delegation set.

delegation_set.name_servers[]
hosted_zone

A complex type that contains general information about the specified hosted zone.

STRUCT(
    "id" VARCHAR,
    "name" VARCHAR,
    "caller_reference" VARCHAR,
    "config" STRUCT(
        "comment" VARCHAR,
        "private_zone" BOOLEAN
    ),
    "resource_record_set_count" BIGINT,
    "linked_service" STRUCT(
        "service_principal" VARCHAR,
        "description" VARCHAR
    )
)
Show child fields
hosted_zone.caller_reference

The value that you specified for CallerReference when you created the hosted zone.

hosted_zone.config

A complex type that includes the Comment and PrivateZone elements. If you omitted the HostedZoneConfig and Comment elements from the request, the Config and Comment elements don't appear in the response.

Show child fields
hosted_zone.config.comment

Any comments that you want to include about the hosted zone.

hosted_zone.config.private_zone

A value that indicates whether this is a private hosted zone.

hosted_zone.id

The ID that Amazon Route 53 assigned to the hosted zone when you created it.

hosted_zone.linked_service

If the hosted zone was created by another service, the service that created the hosted zone. When a hosted zone is created by another service, you can't edit or delete it using Route 53.

Show child fields
hosted_zone.linked_service.description

If the health check or hosted zone was created by another service, an optional description that can be provided by the other service. When a resource is created by another service, you can't edit or delete it using Amazon Route 53.

hosted_zone.linked_service.service_principal

If the health check or hosted zone was created by another service, the service that created the resource. When a resource is created by another service, you can't edit or delete it using Amazon Route 53.

hosted_zone.name

The name of the domain. For public hosted zones, this is the name that you have registered with your DNS registrar.

For information about how to specify characters other than a-z, 0-9, and - (hyphen) and how to specify internationalized domain names, see CreateHostedZone.

hosted_zone.resource_record_set_count

The number of resource record sets in the hosted zone.

vp_cs

A complex type that contains information about the VPCs that are associated with the specified hosted zone.

STRUCT(
    "vpc_region" VARCHAR,
    "vpc_id" VARCHAR
)[]
Show child fields
vp_cs[]
Show child fields
vp_cs[].vpc_id

(Private hosted zones only) The ID of an Amazon VPC.

vp_cs[].vpc_region

(Private hosted zones only) The region that an Amazon VPC was created in.