steampipe plugin install pipes

Table: pipes_organization_member - Query Pipes Organization Members using SQL

Pipes is a data integration service that allows users to connect, transform, and automate data processes across different platforms. An Organization Member in Pipes refers to a user who is part of a specific organization, with assigned roles and permissions to access and manage data processes. This includes information on the user's participation in projects, their roles, and the permissions granted to them.

Table Usage Guide

The pipes_organization_member table provides insights into user memberships within Pipes Organizations. As a data analyst or DevOps engineer, explore user-specific details through this table, including roles, permissions, and project participation. Utilize it to uncover information about users, such as their roles in the organization, their permissions, and their involvement in various projects.

Examples

Basic info

Explore which members belong to your organization and their current status. This can help you manage your team effectively by identifying active and inactive members.

select
id,
org_id,
user_handle,
status
from
pipes_organization_member;
select
id,
org_id,
user_handle,
status
from
pipes_organization_member;

List invited members

Explore which members have been invited to join your organization, helping you keep track of pending invitations and manage your team more effectively.

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

List members with owner role

Explore which members hold the 'owner' role within your organization. This helps in managing access controls and understanding the distribution of administrative responsibilities.

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

Schema for pipes_organization_member

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
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'.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
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_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
version_idbigintThe current version ID for the member.

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_member