Skip to content

aws.privatenetworks.list_orders

Example SQL Queries

SELECT * FROM
aws.privatenetworks.list_orders
WHERE
"network_arn" = 'VALUE';

Description

Lists orders. Add filters to your request to return a more specific list of results. Use filters to match the Amazon Resource Name (ARN) of the network site or the status of the order.

If you specify multiple filters, filters are joined with an OR, and the request returns results that match all of the specified filters.

Table Definition

Column NameColumn Data Type
network_arn Required Input Column

The Amazon Resource Name (ARN) of the network associated with this order.

VARCHAR
filters Input Column

The filters.

  • NETWORK_SITE - The Amazon Resource Name (ARN) of the network site.

  • STATUS - The status (ACKNOWLEDGING | ACKNOWLEDGED | UNACKNOWLEDGED).

Filter values are case sensitive. If you specify multiple values for a filter, the values are joined with an OR, and the request returns all results that match any of the specified values.

MAP(VARCHAR, 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.

acknowledgment_status

The acknowledgement status of the order.

VARCHAR
created_at

The creation time of the order.

TIMESTAMP_S
network_site_arn

The Amazon Resource Name (ARN) of the network site associated with this order.

VARCHAR
order_arn

The Amazon Resource Name (ARN) of the order.

VARCHAR
ordered_resources

A list of the network resources placed in the order.

STRUCT(
"commitment_configuration" STRUCT(
"automatic_renewal" BOOLEAN,
"commitment_length" VARCHAR
),
"count" BIGINT,
"type" VARCHAR
)[]
Show child fields
ordered_resources[]
Show child fields
ordered_resources[].commitment_configuration

The duration and renewal status of the commitment period for each radio unit in the order. Does not show details if the resource type is DEVICE_IDENTIFIER.

Show child fields
ordered_resources[].commitment_configuration.automatic_renewal

Determines whether the commitment period for a radio unit is set to automatically renew for an additional 1 year after your current commitment period expires.

Set to True, if you want your commitment period to automatically renew. Set to False if you do not want your commitment to automatically renew.

You can do the following:

  • Set a 1-year commitment to automatically renew for an additional 1 year. The hourly rate for the additional year will continue to be the same as your existing 1-year rate.

  • Set a 3-year commitment to automatically renew for an additional 1 year. The hourly rate for the additional year will continue to be the same as your existing 3-year rate.

  • Turn off a previously-enabled automatic renewal on a 1-year or 3-year commitment.

You cannot use the automatic-renewal option for a 60-day commitment.

ordered_resources[].commitment_configuration.commitment_length

The duration of the commitment period for the radio unit. You can choose a 60-day, 1-year, or 3-year period.

ordered_resources[].count

The number of network resources in the order.

ordered_resources[].type

The type of network resource in the order.

shipping_address

The shipping address of the order.

STRUCT(
"city" VARCHAR,
"company" VARCHAR,
"country" VARCHAR,
"email_address" VARCHAR,
"name" VARCHAR,
"phone_number" VARCHAR,
"postal_code" VARCHAR,
"state_or_province" VARCHAR,
"street1" VARCHAR,
"street2" VARCHAR,
"street3" VARCHAR
)
Show child fields
shipping_address.city

The city for this address.

shipping_address.company

The company name for this address.

shipping_address.country

The country for this address.

shipping_address.email_address

The recipient's email address.

shipping_address.name

The recipient's name for this address.

shipping_address.phone_number

The recipient's phone number.

shipping_address.postal_code

The postal code for this address.

shipping_address.state_or_province

The state or province for this address.

shipping_address.street1

The first line of the street address.

shipping_address.street2

The second line of the street address.

shipping_address.street3

The third line of the street address.

tracking_information

The tracking information of the order.

STRUCT(
"tracking_number" VARCHAR
)[]
Show child fields
tracking_information[]
Show child fields
tracking_information[].tracking_number

The tracking number of the shipment.