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
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.
Examples
Basic info
select id, org_id, org_handle, statusfrom steampipecloud_organization;
Schema for steampipecloud_organization
Name | Type | Operators | Description |
---|---|---|---|
_ctx | jsonb | Steampipe context in JSON form, e.g. connection_name. | |
avatar_url | text | The avatar URL of the organization. | |
created_at | timestamp with time zone | The time when the organization was created. | |
created_by | jsonb | Information about the user who created the organization. | |
created_by_id | text | The unique identifier of the user who created the organization. | |
display_name | text | The display name for the organization. | |
handle | text | = | The handle name for the organization. |
id | text | The unique identifier for a organization. | |
updated_at | timestamp with time zone | The organization's last update time. | |
updated_by | jsonb | Information about the user who last updated the organization. | |
updated_by_id | text | The unique identifier of the user who last updated the organization. | |
url | text | The URL of the organization. | |
version_id | bigint | The current version ID for the organization. |