Skip to content

aws.outposts.list_catalog_items

Example SQL Queries

SELECT * FROM
aws.outposts.list_catalog_items;

Description

Lists the items in the catalog.

Use filters to return specific results. If you specify multiple filters, the results include only the resources that match all of the specified filters. For a filter where you can specify multiple values, the results include items that match any of the values that you specify for the filter.

Table Definition

Column NameColumn Data Type
ec2_family_filter Input Column

Filters the results by EC2 family (for example, M5).

VARCHAR[]
Show child fields
ec2_family_filter[]
item_class_filter Input Column

Filters the results by item class.

VARCHAR[]
Show child fields
item_class_filter[]
supported_storage_filter Input Column

Filters the results by storage option.

VARCHAR[]
Show child fields
supported_storage_filter[]
_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_region Input Column

The AWS region to use.

VARCHAR
catalog_item_id

The ID of the catalog item.

VARCHAR
ec2_capacities

Information about the EC2 capacity of an item.

STRUCT(
"family" VARCHAR,
"max_size" VARCHAR,
"quantity" VARCHAR
)[]
Show child fields
ec2_capacities[]
Show child fields
ec2_capacities[].family

The family of the EC2 capacity.

ec2_capacities[].max_size

The maximum size of the EC2 capacity.

ec2_capacities[].quantity

The quantity of the EC2 capacity.

item_status

The status of a catalog item.

VARCHAR
power_kva

Information about the power draw of an item.

DOUBLE
supported_storage

The supported storage options for the catalog item.

VARCHAR[]
Show child fields
supported_storage[]
supported_uplink_gbps

The uplink speed this catalog item requires for the connection to the Region.

BIGINT[]
Show child fields
supported_uplink_gbps[]
weight_lbs

The weight of the item in pounds.

BIGINT