Table: steampipecloud_organization_member

Organization members can collaborate and share workspaces and connections.

Examples

select
  id,
  org_id,
  user_handle,
  status
from
  steampipecloud_organization_member;

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

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

Name	Type	Operators	Description
_ctx	jsonb		Steampipe context in JSON form, e.g. connection_name.
created_at	timestamp with time zone		The time when the member was invited.
created_by	jsonb		Information about the user who invited the member.
created_by_id	text		The unique identifier of the user who invited the member.
id	text		The unique identifier for the member.
org_handle	text	=	The handle of the organization.
org_id	text		The unique identifier for the organization.
role	text		The role of the member.
scope	text		The scope of the role. Will always be 'org'.
status	text		The member current status. Possible values are: invited, accepted.
updated_at	timestamp with time zone		The member's last update time.
updated_by	jsonb		Information about the user who last updated the member.
updated_by_id	text		The unique identifier of the user who last updated the member.
user	jsonb		Information about the user.
user_handle	text	=	The handle name for the user.
user_id	text		The unique identifier for the user.
version_id	bigint		The current version ID for the member.