turbot/steampipecloud
steampipe plugin install steampipecloud

Table: steampipecloud_organization_member

Organization members can collaborate and share workspaces and connections.

Examples

Basic info

select
id,
org_id,
user_handle,
status
from
steampipecloud_organization_member;

List invited members

select
id,
org_id,
user_handle,
status
from
steampipecloud_organization_member
where
status = 'invited';

List members with owner role

select
id,
org_id,
user_handle,
status
from
steampipecloud_organization_member
where
role = 'owner';

Schema for steampipecloud_organization_member

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form, e.g. connection_name.
created_attimestamp with time zoneThe time when the member was invited.
created_byjsonbInformation about the user who invited the member.
created_by_idtextThe unique identifier of the user who invited the member.
idtextThe unique identifier for the member.
org_handletext=The handle of the organization.
org_idtextThe unique identifier for the organization.
roletextThe role of the member.
scopetextThe scope of the role. Will always be 'org'.
statustextThe member current status. Possible values are: invited, accepted.
updated_attimestamp with time zoneThe member's last update time.
updated_byjsonbInformation about the user who last updated the member.
updated_by_idtextThe unique identifier of the user who last updated the member.
userjsonbInformation about the user.
user_handletext=The handle name for the user.
user_idtextThe unique identifier for the user.
version_idbigintThe current version ID for the member.