Table: btp_accounts_global_account

Get the details of an SAP BTP global account.

Examples

Get global account details

select
  guid,
  display_name,
  created_date,
  modified_date,
  entity_state,
  state_message,
  subdomain,
  contract_status,
  commercial_model,
  consumption_based
from
  btp_accounts_global_account;

Schema for btp_accounts_global_account

Name	Type	Description
_ctx	jsonb	Steampipe context in JSON form, e.g. connection_name.
commercial_model	text	The type of the commercial contract that was signed.
consumption_based	boolean	Whether the customer of the global account pays only for services that they actually use (consumption-based) or pay for subscribed services at a fixed cost irrespective of consumption (subscription-based). * TRUE: Consumption-based commercial model. * FALSE: Subscription-based commercial model.
contract_status	text	The status of the customer contract and its associated root global account. * ACTIVE: The customer contract and its associated global account is currently active. * PENDING_TERMINATION: A termination process has been triggered for a customer contract (the customer contract has expired, or a customer has given notification that they wish to terminate their contract), and the global account is currently in the validation period. The customer can still access their global account until the end of the validation period. * SUSPENDED: For enterprise accounts, specifies that the customer's global account is currently in the grace period of the termination process. Access to the global account by the customer is blocked. No data is deleted until the deletion date is reached at the end of the grace period. For trial accounts, specifies that the account is suspended, and the account owner has not yet extended the trial period.
created_date	bigint	The date the global account was created. Dates and times are in UTC format.
display_name	text	The display name of the global account.
entity_state	text	The current state of the global account. * STARTED: CRUD operation on an entity has started. * CREATING: Creating entity operation is in progress. * UPDATING: Updating entity operation is in progress. * MOVING: Moving entity operation is in progress. * PROCESSING: A series of operations related to the entity is in progress. * DELETING: Deleting entity operation is in progress. * OK: The CRUD operation or series of operations completed successfully. * PENDING REVIEW: The processing operation has been stopped for reviewing and can be restarted by the operator. * CANCELLED: The operation or processing was canceled by the operator. * CREATION_FAILED: The creation operation failed, and the entity was not created or was created but cannot be used. * UPDATE_FAILED: The update operation failed, and the entity was not updated. * PROCESSING_FAILED: The processing operations failed. * DELETION_FAILED: The delete operation failed, and the entity was not deleted. * MOVE_FAILED: Entity could not be moved to a different location. * MIGRATING: Migrating entity from NEO to CF.
geo_access	text	The geographic locations from where the global account can be accessed. * STANDARD: The global account can be accessed from any geographic location. * EU_ACCESS: The global account can be accessed only within locations in the EU.
guid	text	The unique ID of the global account.
license_type	text	The type of license for the global account. The license type affects the scope of functions of the account. * DEVELOPER: For internal developer global accounts on Staging or Canary landscapes. * CUSTOMER: For customer global accounts. * PARTNER: For partner global accounts. * INTERNAL_DEV: For internal global accounts on the Dev landscape. * INTERNAL_PROD: For internal global accounts on the Live landscape. * TRIAL: For customer trial accounts.
modified_date	bigint	The date the global account was last modified. Dates and times are in UTC format.
renewal_date	bigint	The date that an expired contract was renewed. Dates and times are in UTC format.
state_message	text	Information about the state.
subaccounts	jsonb	The subaccounts in the global account.
subdomain	text	Relevant only for entities that require authorization (e.g. global account). The subdomain that becomes part of the path used to access the authorization tenant of the global account. Unique within the defined region.

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_accounts_global_account