| Column Name | Column Data Type |
|---|
global_network_id Required Input Column
The ID of the global network. | VARCHAR |
device_ids Input Column
One or more device IDs. The maximum is 10. | VARCHAR[] |
Show child fields- device_ids[]
|
site_id Input Column
The site ID. | 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.
|
aws_location
The Amazon Web Services location of the device. | STRUCT(
"zone" VARCHAR,
"subnet_arn" VARCHAR
) |
Show child fields- aws_location.subnet_arn
The Amazon Resource Name (ARN) of the subnet that the device is located in. - aws_location.zone
The Zone that the device is located in. Specify the ID of an Availability Zone, Local Zone, Wavelength Zone, or an Outpost.
|
created_at
The date and time that the site was created. | TIMESTAMP_S |
description
The description of the device. | VARCHAR |
device_arn
The Amazon Resource Name (ARN) of the device. | VARCHAR |
device_id
The ID of the device. | VARCHAR |
location
The site location. | STRUCT(
"address" VARCHAR,
"latitude" VARCHAR,
"longitude" VARCHAR
) |
Show child fields- location.address
The physical address. - location.latitude
The latitude. - location.longitude
The longitude.
|
model
The device model. | VARCHAR |
serial_number
The device serial number. | VARCHAR |
state
The device state. | VARCHAR |
tags
The tags for the device. | STRUCT(
"key" VARCHAR,
"value" VARCHAR
)[] |
Show child fields- tags[]
Show child fields- tags[].key
The tag key. Constraints: Maximum length of 128 characters. - tags[].value
The tag value. Constraints: Maximum length of 256 characters.
|
type
The device type. | VARCHAR |
vendor
The device vendor. | VARCHAR |