Skip to content
AWS for Query.Farm

aws.route53.list_hosted_zones

Example SQL Queries

SELECT * FROM
aws.route53.list_hosted_zones;

Description

Retrieves a list of the public and private hosted zones that are associated with the current Amazon Web Services account. The response includes a HostedZones child element for each hosted zone.

Amazon Route 53 returns a maximum of 100 items in each response. If you have a lot of hosted zones, you can use the maxitems parameter to list them in groups of up to 100.

Table Definition

Column NameColumn Data Type
delegation_set_id Input Column

If you're using reusable delegation sets and you want to list all of the hosted zones that are associated with a reusable delegation set, specify the ID of that reusable delegation set. 

VARCHAR
hosted_zone_type Input Column

(Optional) Specifies if the hosted zone is private. 

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.

hosted_zones

A complex type that contains general information about the 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_zones[]
Show child fields
hosted_zones[].caller_reference

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

hosted_zones[].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_zones[].config.comment

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

hosted_zones[].config.private_zone

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

hosted_zones[].id

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

hosted_zones[].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_zones[].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_zones[].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_zones[].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_zones[].resource_record_set_count

The number of resource record sets in the hosted zone.

marker

For the second and subsequent calls to ListHostedZones, Marker is the value that you specified for the marker parameter in the request that produced the current response.

VARCHAR
max_items

The value that you specified for the maxitems parameter in the call to ListHostedZones that produced the current response.

VARCHAR