Table: steampipecloud_organization_workspace_member

Organization Workspace members can collaborate and share connections and dashboards.

Examples

Basic info

select
  id,
  org_handle,
  workspace_handle,
  user_handle,
  status,
  role
from
  steampipecloud_organization_workspace_member;

List invited members

select
  id,
  org_handle,
  workspace_handle,
  user_handle,
  status,
  role
from
  steampipecloud_organization_workspace_member
where
  status = 'invited';

List owners of an organization workspace

select
  id,
  org_handle,
  workspace_handle,
  user_handle,
  status,
  role
from
  steampipecloud_organization_workspace_member
where
  org_handle = 'testorg'
  and workspace_handle = 'dev'
  and role = 'owner';

Get details of a particular member in an organization workspace

select
  id,
  org_handle,
  workspace_handle,
  user_handle,
  status,
  role
from
  steampipecloud_organization_workspace_member
where
  org_handle = 'testorg'
  and workspace_handle = 'dev'
  and user_handle = 'myuser';

Schema for steampipecloud_organization_workspace_member

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 added.
created_by	jsonb		Information about the user who added the member.
created_by_id	text		The unique identifier of the user who added 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. Can be one of org / workspace.
status	text		The member current status.
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		Additional 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.
workspace_handle	text	=	The handle of the workspace.
workspace_id	text		The unique identifier for the workspace.