Table: btp_accounts_directory

Get the details of a directory in your global account.

Examples

Get directory

select
  guid,
  display_name,
  created_date,
  entity_state,
  state_message,
  subaccounts
from
  btp_accounts_directory
where
  guid = '35170704-2231-2v14-q4x1-c017f2525076';

List all directories in a Global account

select
  distinct parent_guid,
  parent_type
from
  btp_accounts_subaccount
where
  parent_type = 'PROJECT';

Schema for btp_accounts_directory

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
consumption_based	boolean		True if the account is consumption based.
contract_status	text		The status of the customer contract and its associated root global account. * <b>ACTIVE:</b> The customer contract and its associated global account is currently active. * <b>PENDING_TERMINATION:</b> 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. * <b>SUSPENDED:</b> 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_by	text		Details of the user that created the directory.
created_date	bigint		The date the directory was created. Dates and times are in UTC format.
custom_properties	jsonb		The custom properties of the directory.
directory_features	jsonb		The features of the directory.
directory_type	text		Type of directory.
display_name	text		The display name of the directory.
entity_state	text		The current state of the directory. * <b>STARTED:</b> CRUD operation on an entity has started. * <b>CREATING:</b> Creating entity operation is in progress. * <b>UPDATING:</b> Updating entity operation is in progress. * <b>MOVING:</b> Moving entity operation is in progress. * <b>PROCESSING:</b> A series of operations related to the entity is in progress. * <b>DELETING:</b> Deleting entity operation is in progress. * <b>OK:</b> The CRUD operation or series of operations completed successfully. * <b>PENDING REVIEW:</b> The processing operation has been stopped for reviewing and can be restarted by the operator. * <b>CANCELLED:</b> The operation or processing was canceled by the operator. * <b>CREATION_FAILED:</b> The creation operation failed, and the entity was not created or was created but cannot be used. * <b>UPDATE_FAILED:</b> The update operation failed, and the entity was not updated. * <b>PROCESSING_FAILED:</b> The processing operations failed. * <b>DELETION_FAILED:</b> The delete operation failed, and the entity was not deleted. * <b>MOVE_FAILED:</b> Entity could not be moved to a different location. * <b>MIGRATING:</b> Migrating entity from NEO to CF.
global_account_guid	text		The GUID of the directory's global account entity.
guid	text	=	The unique ID of the directory.
modified_date	bigint		The date the directory was last modified. Dates and times are in UTC format.
parent_guid0	text		The GUID of the directory's parent entity. Typically this is the global account.
parent_guid1	text		The GUID1 of the directory's parent entity. Typically this is the global account.
parent_type	text		The Type of the directory parent entity.
state_message	text		Information about the state.
subaccounts	jsonb		The subaccounts the directory.

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_directory