steampipe plugin install pipes

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

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
created_attimestamp with time zoneThe time when the member was added.
created_byjsonbInformation about the user who added the member.
created_by_idtextThe unique identifier of the user who added 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. Can be one of org / workspace.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
statustextThe member current status.
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.
userjsonbAdditional information about the user.
user_handletext=The handle name for the user.
user_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
version_idbigintThe current version ID for the member.
workspace_handletext=The handle of the workspace.
workspace_idtextThe 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