| Column Name | Column Data Type |
|---|
filter_name Input Column
The filter to use to limit the number of results. | VARCHAR |
filter_value Input Column
The value to use for the filter. | VARCHAR |
max_results Input Column
The maximum number of results to return in a single call. | BIGINT |
next_token Input Column
The token to use to retrieve the next page of results. | VARCHAR |
product_type Input Column
The phone number product type. | VARCHAR |
status Input Column
The phone number status. | 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.
|
phone_numbers
The phone number details. | STRUCT(
"phone_number_id" VARCHAR,
"e164_phone_number" VARCHAR,
"country" VARCHAR,
"type" VARCHAR,
"product_type" VARCHAR,
"status" VARCHAR,
"capabilities" STRUCT(
"inbound_call" BOOLEAN,
"outbound_call" BOOLEAN,
"inbound_sms" BOOLEAN,
"outbound_sms" BOOLEAN,
"inbound_mms" BOOLEAN,
"outbound_mms" BOOLEAN
),
"associations" STRUCT(
"value" VARCHAR,
"name" VARCHAR,
"associated_timestamp" TIMESTAMP_S
)[],
"calling_name" VARCHAR,
"calling_name_status" VARCHAR,
"created_timestamp" TIMESTAMP_S,
"updated_timestamp" TIMESTAMP_S,
"deletion_timestamp" TIMESTAMP_S
)[] |
Show child fields- phone_numbers[]
Show child fields- phone_numbers[].associations[]
Show child fields- phone_numbers[].associations[].associated_timestamp
The timestamp of the phone number association, in ISO 8601 format. - phone_numbers[].associations[].name
Defines the association with an Amazon Chime account ID, user ID, Amazon Chime Voice Connector ID, or Amazon Chime Voice Connector group ID. - phone_numbers[].associations[].value
Contains the ID for the entity specified in Name.
- phone_numbers[].calling_name
The outbound calling name associated with the phone number. - phone_numbers[].calling_name_status
The outbound calling name status. - phone_numbers[].capabilities
The phone number capabilities. Show child fields- phone_numbers[].capabilities.inbound_call
Allows or denies inbound calling for the specified phone number. - phone_numbers[].capabilities.inbound_mms
Allows or denies inbound MMS messaging for the specified phone number. - phone_numbers[].capabilities.inbound_sms
Allows or denies inbound SMS messaging for the specified phone number. - phone_numbers[].capabilities.outbound_call
Allows or denies outbound calling for the specified phone number. - phone_numbers[].capabilities.outbound_mms
Allows or denies outbound MMS messaging for the specified phone number. - phone_numbers[].capabilities.outbound_sms
Allows or denies outbound SMS messaging for the specified phone number.
- phone_numbers[].country
The phone number country. Format: ISO 3166-1 alpha-2. - phone_numbers[].created_timestamp
The phone number creation timestamp, in ISO 8601 format. - phone_numbers[].deletion_timestamp
The deleted phone number timestamp, in ISO 8601 format. - phone_numbers[].e164_phone_number
The phone number, in E.164 format. - phone_numbers[].phone_number_id
The phone number ID. - phone_numbers[].product_type
The phone number product type. - phone_numbers[].status
The phone number status. - phone_numbers[].type
The phone number type. - phone_numbers[].updated_timestamp
The updated phone number timestamp, in ISO 8601 format.
|