aws.privatenetworks.get_network_resource

Example SQL Queries

SELECT * FROM
aws.privatenetworks.get_network_resource
WHERE
"network_resource_arn" = 'VALUE';

Description

Gets the specified network resource.

• View All PrivateNetworks Tables
• Boto3 Reference

Table Definition

Column Name	Column Data Type
network_resource_arn Required Input Column The Amazon Resource Name (ARN) of the network resource.	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.
network_resource Information about the network resource.	STRUCT( "attributes" STRUCT( "name" VARCHAR, "value" VARCHAR )[], "commitment_information" STRUCT( "commitment_configuration" STRUCT( "automatic_renewal" BOOLEAN, "commitment_length" VARCHAR ), "expires_on" TIMESTAMP_S, "start_at" TIMESTAMP_S ), "created_at" TIMESTAMP_S, "description" VARCHAR, "health" VARCHAR, "model" VARCHAR, "network_arn" VARCHAR, "network_resource_arn" VARCHAR, "network_site_arn" VARCHAR, "order_arn" VARCHAR, "position" STRUCT( "elevation" DOUBLE, "elevation_reference" VARCHAR, "elevation_unit" VARCHAR, "latitude" DOUBLE, "longitude" DOUBLE ), "return_information" STRUCT( "replacement_order_arn" VARCHAR, "return_reason" 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 ), "shipping_label" VARCHAR ), "serial_number" VARCHAR, "status" VARCHAR, "status_reason" VARCHAR, "type" VARCHAR, "vendor" VARCHAR )
Show child fields network_resource.attributes[] Show child fields network_resource.attributes[].name The name of the pair. network_resource.attributes[].value The value of the pair. network_resource.commitment_information Information about the commitment period for the radio unit. Shows the duration, the date and time that the contract started and ends, and the renewal status of the commitment period. Show child fields network_resource.commitment_information.commitment_configuration The duration and renewal status of the commitment period for the radio unit. Show child fields network_resource.commitment_information.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. network_resource.commitment_information.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. network_resource.commitment_information.expires_on The date and time that the commitment period ends. If you do not cancel or renew the commitment before the expiration date, you will be billed at the 60-day-commitment rate. network_resource.commitment_information.start_at The date and time that the commitment period started. network_resource.created_at The creation time of the network resource. network_resource.description The description of the network resource. network_resource.health The health of the network resource. network_resource.model The model of the network resource. network_resource.network_arn The Amazon Resource Name (ARN) of the network on which this network resource appears. network_resource.network_resource_arn The Amazon Resource Name (ARN) of the network resource. network_resource.network_site_arn The Amazon Resource Name (ARN) of the network site on which this network resource appears. network_resource.order_arn The Amazon Resource Name (ARN) of the order used to purchase this network resource. network_resource.position The position of the network resource. Show child fields network_resource.position.elevation The elevation of the equipment at this position. network_resource.position.elevation_reference The reference point from which elevation is reported. network_resource.position.elevation_unit The units used to measure the elevation of the position. network_resource.position.latitude The latitude of the position. network_resource.position.longitude The longitude of the position. network_resource.return_information Information about a request to return the network resource. Show child fields network_resource.return_information.replacement_order_arn The Amazon Resource Name (ARN) of the replacement order. network_resource.return_information.return_reason The reason for the return. If the return request did not include a reason for the return, this value is null. network_resource.return_information.shipping_address The shipping address. Show child fields network_resource.return_information.shipping_address.city The city for this address. network_resource.return_information.shipping_address.company The company name for this address. network_resource.return_information.shipping_address.country The country for this address. network_resource.return_information.shipping_address.email_address The recipient's email address. network_resource.return_information.shipping_address.name The recipient's name for this address. network_resource.return_information.shipping_address.phone_number The recipient's phone number. network_resource.return_information.shipping_address.postal_code The postal code for this address. network_resource.return_information.shipping_address.state_or_province The state or province for this address. network_resource.return_information.shipping_address.street1 The first line of the street address. network_resource.return_information.shipping_address.street2 The second line of the street address. network_resource.return_information.shipping_address.street3 The third line of the street address. network_resource.return_information.shipping_label The URL of the shipping label. The shipping label is available for download only if the status of the network resource is PENDING_RETURN. For more information, see Return a radio unit. network_resource.serial_number The serial number of the network resource. network_resource.status The status of the network resource. network_resource.status_reason The status reason of the network resource. network_resource.type The type of the network resource. network_resource.vendor The vendor of the network resource.
tags The network resource 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.