Skip to content

aws.route53domains.list_operations

Example SQL Queries

SELECT * FROM
aws.route53domains.list_operations;

Description

Returns information about all of the operations that return an operation ID and that have ever been performed on domains that were registered by the current account.

This command runs only in the us-east-1 Region.

Table Definition

Column NameColumn Data Type
sort_by Input Column

The sort type for returned values.

VARCHAR
sort_order Input Column

The sort order for returned values, either ascending or descending.

VARCHAR
submitted_since Input Column

An optional parameter that lets you get information about all the operations that you submitted after a specified date and time. Specify the date and time in Unix time format and Coordinated Universal time (UTC).

TIMESTAMP_S
_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.

_aws_region Input Column

The AWS region to use.

VARCHAR
_input_status Input Column
VARCHAR[]
Show child fields
_input_status[]
_input_type Input Column
VARCHAR[]
Show child fields
_input_type[]
domain_name

Name of the domain.

VARCHAR
last_updated_date

The date when the last change was made in Unix time format and Coordinated Universal Time (UTC).

TIMESTAMP_S
message

Message about the operation.

VARCHAR
operation_id

Identifier returned to track the requested action.

VARCHAR
status

The current status of the requested operation in the system.

VARCHAR
status_flag

Automatically checks whether there are no outstanding operations on domains that need customer attention.

Valid values are:

  • PENDING_ACCEPTANCE: The operation is waiting for acceptance from the account that is receiving the domain.

  • PENDING_CUSTOMER_ACTION: The operation is waiting for customer action, for example, returning an email.

  • PENDING_AUTHORIZATION: The operation is waiting for the form of authorization. For more information, see ResendOperationAuthorization.

  • PENDING_PAYMENT_VERIFICATION: The operation is waiting for the payment method to validate.

  • PENDING_SUPPORT_CASE: The operation includes a support case and is waiting for its resolution.

VARCHAR
submitted_date

The date when the request was submitted.

TIMESTAMP_S
type

Type of the action requested.

VARCHAR