Table: aws_servicecatalog_portfolio - Query AWS Service Catalog Portfolio using SQL

The AWS Service Catalog Portfolio is a part of the AWS Service Catalog that allows you to manage, organize, and govern your cloud resources. It enables you to create and manage catalogs of IT services that are approved for use on AWS. These IT Service Catalogs can help you achieve consistent governance and meet your compliance requirements, while enabling users to quickly deploy only the approved IT services they need.

Table Usage Guide

The aws_servicecatalog_portfolio table in Steampipe provides you with information about portfolios within AWS Service Catalog. This table allows you, as a DevOps engineer, to query portfolio-specific details, including owner, description, created time, and associated metadata. You can utilize this table to gather insights on portfolios, such as portfolio details, associated products, and more. The schema outlines the various attributes of the portfolio for you, including the portfolio ARN, creation date, and associated tags.

Examples

Basic info

Explore the portfolios available in your AWS Service Catalog to understand which resources are accessible for deployment across your organization. This can help manage and govern cloud resources more effectively.

select
  display_name,
  id,
  arn,
  region,
  akas
from
  aws_servicecatalog_portfolio;

select
  display_name,
  id,
  arn,
  region,
  akas
from
  aws_servicecatalog_portfolio;

List portfolios of a provider

Determine the portfolios associated with a specific provider to understand the range of services they offer. This can help in comparing and selecting suitable service providers based on your needs.

select
  display_name,
  id,
  description,
  provider_name
from
  aws_servicecatalog_portfolio
where
  provider_name = 'my-portfolio';

select
  display_name,
  id,
  description,
  provider_name
from
  aws_servicecatalog_portfolio
where
  provider_name = 'my-portfolio';

List portfolios created in the last 30 days

Gain insights into the most recently created portfolios within the past month. This is beneficial for tracking the latest additions and updates in your AWS Service Catalog.

select
  display_name,
  id,
  description,
  created_time
from
  aws_servicecatalog_portfolio
where
  created_time >= now() - interval '30' day;

select
  display_name,
  id,
  description,
  created_time
from
  aws_servicecatalog_portfolio
where
  created_time >= datetime('now', '-30 day');

Get budget details of portfolios

Discover the segments that are costing you the most by understanding the budget allocation across various portfolios. This can aid in better financial management by identifying areas that require cost optimization.

select
  sp.display_name,
  sp.id,
  b ->> 'BudgetName' as budget_name
from
  aws_servicecatalog_portfolio as sp,
  jsonb_array_elements(budgets) as b;

select
  sp.display_name,
  sp.id,
  json_extract(b.value, '$.BudgetName') as budget_name
from
  aws_servicecatalog_portfolio as sp,
  json_each(budgets) as b;

This table is available as a standalone Exporter CLI. Steampipe exporters are stand-alone binaries that allow you to extract data using Steampipe plugins without a database.

You can download the tarball for your platform from the Releases page, but it is simplest to install them with the steampipe_export_installer.sh script:

/bin/sh -c "$(curl -fsSL https://steampipe.io/install/export.sh)" -- aws

You can pass the configuration to the command with the --config argument:

steampipe_export_aws --config '<your_config>' aws_servicecatalog_portfolio