Table: pipes_organization_workspace_member - Query Pipes Organization Workspace Members using SQL

Pipes is a service that allows users to connect, transform, and observe data in motion. Within an organization's workspace in Pipes, members are the users who have access to the workspace and its resources. This table provides data about these members, including their roles, permissions, and other related details. Organization Workspace members can collaborate and share connections and dashboards.

Table Usage Guide

The pipes_organization_workspace_member table provides insights into the members within a Pipes Organization Workspace. As a data analyst or a DevOps engineer, you can explore member-specific details through this table, including their roles, permissions, and other associated metadata. Utilize it to uncover information about members, such as those with administrative permissions, the roles assigned to various members, and the verification of their access rights.

Examples

Basic info

Explore which users are part of your organization's workspace in Steampipe and understand their roles and status. This can help in managing access and determining the level of participation of each member.

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

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

List invited members

Explore which members have been invited to join your organization's workspace. This can be useful in managing your team's access and roles, ensuring that all necessary invites have been sent, and tracking the status of these invitations.

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

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

List owners of an organization workspace

Explore which users have the 'owner' role in a specific organization workspace. This is beneficial in managing permissions and roles within the workspace, ensuring the right people have access to certain features and data.

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

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

Get details of a particular member in an organization workspace

Explore the status and role of a specific member within a particular workspace of an organization. This can help in understanding their access level and their contribution within the workspace.

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

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

Schema for pipes_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.

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)" -- pipes

You can pass the configuration to the command with the --config argument:

steampipe_export_pipes --config '<your_config>' pipes_organization_workspace_member