aws.privatenetworks.get_order

Example SQL Queries

SELECT * FROM
aws.privatenetworks.get_order
WHERE
"order_arn" = 'VALUE';

Description

Gets the specified order.

• View All PrivateNetworks Tables
• Boto3 Reference

Table Definition

Column Name	Column Data Type
order_arn Required Input Column The Amazon Resource Name (ARN) of the order.	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.
order Information about the order.	STRUCT( "acknowledgment_status" VARCHAR, "created_at" TIMESTAMP_S, "network_arn" VARCHAR, "network_site_arn" VARCHAR, "order_arn" VARCHAR, "ordered_resources" STRUCT( "commitment_configuration" STRUCT( "automatic_renewal" BOOLEAN, "commitment_length" VARCHAR ), "count" BIGINT, "type" VARCHAR )[], "shipping_address" 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 ), "tracking_information" STRUCT( "tracking_number" VARCHAR )[] )
Show child fields order.acknowledgment_status The acknowledgement status of the order. order.created_at The creation time of the order. order.network_arn The Amazon Resource Name (ARN) of the network associated with this order. order.network_site_arn The Amazon Resource Name (ARN) of the network site associated with this order. order.order_arn The Amazon Resource Name (ARN) of the order. order.ordered_resources[] Show child fields order.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 order.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. order.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. order.ordered_resources[].count The number of network resources in the order. order.ordered_resources[].type The type of network resource in the order. order.shipping_address The shipping address of the order. Show child fields order.shipping_address.city The city for this address. order.shipping_address.company The company name for this address. order.shipping_address.country The country for this address. order.shipping_address.email_address The recipient's email address. order.shipping_address.name The recipient's name for this address. order.shipping_address.phone_number The recipient's phone number. order.shipping_address.postal_code The postal code for this address. order.shipping_address.state_or_province The state or province for this address. order.shipping_address.street1 The first line of the street address. order.shipping_address.street2 The second line of the street address. order.shipping_address.street3 The third line of the street address. order.tracking_information[] Show child fields order.tracking_information[].tracking_number The tracking number of the shipment.
tags The order tags.	MAP(VARCHAR, VARCHAR)

Note

Tables may require input columns to have values specified before the table can return it’s rows. The values for input parameters are set in the where clause of the query typically using = or IN.