steampipecloud_audit_logsteampipecloud_connectionsteampipecloud_organizationsteampipecloud_organization_membersteampipecloud_organization_workspace_membersteampipecloud_processsteampipecloud_tokensteampipecloud_usersteampipecloud_user_emailsteampipecloud_user_preferencessteampipecloud_workspacesteampipecloud_workspace_aggregatorsteampipecloud_workspace_connectionsteampipecloud_workspace_db_logsteampipecloud_workspace_modsteampipecloud_workspace_mod_variablesteampipecloud_workspace_pipelinesteampipecloud_workspace_processsteampipecloud_workspace_snapshot
Table: steampipecloud_organization_member
Organization members can collaborate and share workspaces and connections.
Examples
Basic info
select id, org_id, user_handle, statusfrom steampipecloud_organization_member;
List invited members
select id, org_id, user_handle, statusfrom steampipecloud_organization_memberwhere status = 'invited';
List members with owner role
select id, org_id, user_handle, statusfrom steampipecloud_organization_memberwhere role = 'owner';
Schema for steampipecloud_organization_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 invited. | |
created_by | jsonb | Information about the user who invited the member. | |
created_by_id | text | The unique identifier of the user who invited 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. Will always be 'org'. | |
status | text | The member current status. Possible values are: invited, accepted. | |
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 | 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. |