Table: btp_entitlements_datacenter

Get the details of all the data centers where a subaccount can be created in the SAP BTP global account.

Examples

List all the allowed data centers

select
  display_name,
  region,
  environment,
  iaas_provider,
  supports_trial,
  domain,
  is_main_data_center
from
  btp_entitlements_datacenter;

List all the Cloud Foundry data centers

select
  display_name,
  region,
  environment,
  iaas_provider,
  supports_trial,
  domain,
  is_main_data_center
from
  btp_entitlements_datacenter
where
  environment = 'cloudfoundry';

List all the satellite data centers

select
  display_name,
  region,
  environment,
  iaas_provider,
  supports_trial,
  domain
from
  btp_entitlements_datacenter
where
  is_main_data_center = False;

Subaccount details with datacenter information

select
  sa.guid subaccount_guid,
  sa.display_name subaccount_name,
  sa.subdomain subaccount_subdomain,
  dc.name dc_name,
  dc.display_name as dc_location,
  sa.region,
  environment,
  dc.iaas_provider,
  supports_trial,
  saas_registry_service_url,
  domain,
  geo_access
from
  btp_accounts_subaccount sa
  join btp_entitlements_datacenter dc on sa.region = dc.region
order by
  region,
  subaccount_name;

Schema for btp_entitlements_datacenter

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
display_name	text		Descriptive name of the data center for customer-facing UIs.
domain	text		The domain of the data center.
environment	text		The environment that the data center supports. For example: Kubernetes, Cloud Foundry.
geo_access	text		The geographical access of the data center. Valid values: GLOBAL, REGIONAL.
iaas_provider	text		The infrastructure provider for the data center. Valid values: AWS, GCP, AZURE, SAP: SAP BTP (Neo), ALI: Alibaba Cloud, IBM: IBM Cloud.
is_main_data_center	boolean		Whether the specified datacenter is a main datacenter.
name	text		Technical name of the data center. Must be unique within the cloud deployment.
provisioning_service_url	text		Provisioning service URL.
region	text	=	The region in which the data center is located.
saas_registry_service_url	text		Saas-Registry service URL.
supports_trial	boolean		Whether the specified datacenter supports trial accounts.

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_datacenter