steampipe plugin install pipes

Table: pipes_organization - Query Pipes Organizations using SQL

Users can create their own connections and workspaces, but they are not shared with other users. Organizations, on the other hand, include multiple users and are intended for organizations to collaborate and share workspaces and connections.

Table Usage Guide

The pipes_organization table provides insights into Organizations within Pipes. As a data engineer, explore organization-specific details through this table, including the name, description, and creation date of the organization. Utilize it to uncover information about organizations, such as those with specific data flows, the relationships between organizations, and the verification of data pipelines.

Examples

Basic info

Analyze the status of different organizational entities within your system. This is useful to understand the overall health and activity status of various organizations for effective management.

select
id,
org_id,
org_handle,
status
from
pipes_organization;
select
id,
org_id,
org_handle,
status
from
pipes_organization;

Schema for pipes_organization

NameTypeOperatorsDescription
_ctxjsonbSteampipe context in JSON form.
avatar_urltextThe avatar URL of the organization.
created_attimestamp with time zoneThe time when the organization was created.
created_byjsonbInformation about the user who created the organization.
created_by_idtextThe unique identifier of the user who created the organization.
display_nametextThe display name for the organization.
handletext=The handle name for the organization.
idtextThe unique identifier for a organization.
sp_connection_nametext=, !=, ~~, ~~*, !~~, !~~*Steampipe connection name.
sp_ctxjsonbSteampipe context in JSON form.
updated_attimestamp with time zoneThe organization's last update time.
updated_byjsonbInformation about the user who last updated the organization.
updated_by_idtextThe unique identifier of the user who last updated the organization.
urltextThe URL of the organization.
user_idtext=, !=, ~~, ~~*, !~~, !~~*The unique identifier for the user.
version_idbigintThe current version ID for the organization.

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