Table: btp_entitlements_assignment

Get the details of all the service assignments available to the SAP BTP global account.

Examples

Get the business category of all services

select
  distinct business_category ->> 'id' bc_id
from
  btp_entitlements_assignment;

Nested JSON structures in the Entitlements API

select
  bes.display_name,
  service_plans
from
  btp_entitlements_assignment;

Assignments and quota for a particular business category

select
  bes.display_name,
  service_plan ->> 'name' sp_displayname,
  service_plan ->> 'amount' sp_amount,
  service_plan ->> 'remainingamount' sp_remaining_amount
from
  btp_entitlements_assignment bes
  cross join jsonb_array_elements(service_plans) service_plan
where
  business_category ->> 'id' = 'AI'
order by
  bes.display_name asc;

Assignments and the data centers where they are available

select
  bes.display_name,
  service_plan ->> 'name' sp_displayname,
  data_centers ->> 'name' dc_name
from
  btp_entitlements_assignment bes
  cross join jsonb_array_elements(service_plans) service_plan
  cross join jsonb_array_elements(service_plan -> 'datacenters') data_centers
where
  business_category ->> 'id' = 'INTEGRATION'
  and data_centers ->> 'name' = 'cf-eu10'
order by
  bes.display_name asc;

Schema for btp_entitlements_assignment

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
business_category	jsonb	Services grouped according to capabilities and customer’s business needs, for example, Extension Suite - Digital Experience, Extension Suite - Development Efficiency, and Extension Suite - Digital Process Automation. Possible values: OTHER, APPLICATION_DEVELOPMENT_AND_AUTOMATION, INTEGRATION, FOUNDATION_CROSS_SERVICES, AI, DATA_AND_ANALYTICS, EXTENDED_PLANNING_AND_ANALYSIS.
description	text	Description of the service for customer-facing UIs.
display_name	text	Display name of the service for customer-facing UIs.
icon_base64	text	The icon of the service in Base64 format.
name	text	The unique registration name of the deployed service as defined by the service provider.
owner_type	text	The owner type of the service. Possible values: VENDOR: The owner is a service owner, who is affiliated with the cloud operator, that added the service to the product catalog for general consumption. CUSTOMER: The owner is an SAP customer that added a custom service to the product catalog, and it is available only for consumption within the customer's global account. PARTNER: The owner is an SAP partner that added the service to the product catalog, and it is available only to their customers for consumption.
service_plans	jsonb	List of service plans associated with the entitled service.
terms_of_use_url	text	Terms of use.

Export

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)" -- btp

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

steampipe_export_btp --config '<your_config>' btp_entitlements_assignment